In modern application development, exposing database logic as REST APIs is a powerful way to integrate systems. Oracle REST Data Services (ORDS) makes it easy to turn PL/SQL into RESTful APIs without needing a separate backend service.
In this blog, we’ll walk through how to create a simple POST API using ORDS and PL/SQL to insert data into a table.
Pre-requisites
- A cloud-based ATP wallet (I prefer)
Let's start how we create the APIs on the top of any custom table which relies on databases
Create a table in the oracle SQL Developer
and followed by create an ORDS Module
1.Create an ORDS Module
A module is a logical container for related REST endpoints.
What this Module does ??
- Creates a module named nj_api
- Defines base URL: http://server_name/ords/table_Schema/nj_api/
2: Define a Template (Endpoint Path)
A template represents the API endpoint path.
It defines how Endpoint URL:/ords/table_schema/nj_api/insert_data
3: Define the Handler (Business Logic)
The handler contains the logic executed when the API is called.
Key Concepts:
- p_method => 'POST': Defines HTTP method
- p_source_type => ORDS.source_type_plsql: Uses PL/SQL block
- Bind variables (:name, :num, etc.) map directly to JSON request body parameters 4: Testing the API Using Tools like Postman,cURL,ORDS REST Workshop I tested with Postman FYR
Let's call same in Oracle VBCS in new blog...
Try other methods like Delete, PATCH & GET