This post assumes you installed ORDS 23.2 in FREEPDB1, the initial Pluggable Database available with Oracle Database 23c Free-Developer Release. In my case I simply ords-enabled my own schema, "MARTIN". If you would like to follow along you need to grant the following privileges to the user:
Additionally you might need space quotas on your assigned tablespaces. After your schema is enabled (see ORDS.enable_schema() in the documentation set for details) you can point your browser to Database Actions using the following URL:
You will be prompted for your database username and password. Once authenticated you are presented with the launchpad:
A quick mouse-click on the diskette icon stores the module in the database. The navigator panel on the left shows the new module:
In the ensuing dialog click on the exported function’s name, switch the toggle to “function” and set the output type to JSON. Database Actions identifies the parameter and makes a suggestion of its data type.
If you aren’t happy with the suggested data type select one that’s more appropriate from the “Type” drop down. Click on “Create” to persist the call specification in the database.
If you prefer a graphical user interface for writing your code online, then Database Actions might just be the thing for you. The functionality has been available with 23.1.n as well but the new release enhances the experience substantially. Feel free to give the combination of ORDS 23.2.0 and Oracle Database 23c Free-Developer Release a try. Any feedback is good feedback, if you like you can share yours in the dedicated forum. Happy coding!
Martin is a product manager at Oracle helping customers in Europe and around the world address their IT related problems. He is most interested in cloud technology, DevOps and how these can be used best with Oracle technology.