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
edited Apr 16, 2022 7:56AM in Autonomous Database 3 comments


ORDS, ATP database


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 ( 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:

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.


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