Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Registering own schema to publish custom packages on Oracle database in ATP — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Registering own schema to publish custom packages on Oracle database in ATP

Received Response
10
Views
3
Comments
edited Apr 16, 2022 7:56AM in Autonomous Database 3 comments

Summary

ORDS, ATP database

Content

We have created ATP database. In the database, we created new schema called YOUR_APP_SCHEMA and create HR tables. We registered schema for REST services (ords.enable_schema with yas mapping pattern). We created one simple package with one procedure (welcome.page). Procedure returns some text in output (using htp.p).

The question is. Is it possible to run procedure directly from YOUR_APP_SCHEMA schema like:

https://link.com/ords/yas/welcome.page

In this case we are getting error 404.

If we add grant execute privileges of this function to user ords_public_user then we can run it. The link is like:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!