Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need simplified approach for managing 250+ REST APIs in ORDS

To make a custom REST API functional in ORDS, we need to enable the schema, define a module, set up a template, and create a PL/SQL block in the handlers with specific logic to call the stored procedure.

Is there an alternative, simpler approach in ORDS where we can enable objects or packages at the DB level, allowing GET/POST operations to work without requiring individual handler creation changes for each API ?

Note: Our application contains over 250 REST API calls, and making individual changes for each API based on the logic of the stored procedures would be complex and challenging to maintain.

Comments
Post Details
Added on Apr 22 2025
0 comments
196 views