Registering own schema to publish custom packages on Oracle database in ATP
Summary
ORDS, ATP databaseContent
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:
0