REST enabling PL/SQL
ORDS has a feature named auto-plsql enablement. While this is the fastest way to access and leverage existing PLSQL logic via HTTP it is not ‘REST’. REST implies much more and there’s many answers and explaination out there such as Stack Overflow , REST API Tutorial, Wikipedia, and lots more.
The easiest way to enable a PLSQL object is to use our PLSQL API. Here’s an example of enabling a procedure that has 1 IN/OUT which is TIMESTAMP WITH LOCAL TIME ZONE.
A new feature in ORDS 17.3 is the generation of OpenAPI definitions. This is format from https://swagger.io/ for documentation of a REST API. There are many tools that support this standard and can simply import the definition and offer a way to test the endpoint automatically.
Open API for this procedure
Postman has an import feature which takes in the link for the swagger json above. Once it’s imported the tool makes a Collection in the sidebar for everything imported.
Getting the JQuery
- 1 PLSQL API call to enable the procedure
- Get the URL for the automatically generated Swagger JSON
- Import into Postman
- Get working code.
- Now leveraging existing pl/sql logic from anywhere.