Create a RESTful web service in Oracle Database Cloud Service

To Open the Oracle Application Express

Go to sign in with your credentials.


After signing in to the cloud click on the Sign in to My Services > button, before that select your data center.


In the Oracle Cloud My Services tab select the businessintelldb(Database Schema). In the service details of the businessintelldb(Database Schema) Open Service Console.




Step 1: Go to the Application Express of the Cloud Service. Click on the SQL workshop. Then on the RESTful Services.





Step 2: Create a module for the RESTful service module in the way as follows.




Step 3: Click on GET method after you see the message on top RESTful Service successfully created.



Step 4: Then you can click on the test button under the Source tab to check the RESTful service handler.When you click on Test you can see the result of the query in the source returned from the DEMO_ORDERS table from the cloud database in a new window.



Step 5: Now create a new template for retrieving the data by a particular value. Pass the URI template and /{name_of_column} i.e. the column you will select values from. This name is visible on the url when you try to access the result.



Step 6:  After creating the template you have to create a handler of that template by the method GET. Do not forget to change the Require Service access to ‘No’. And write the query   # select * from DEMO_ORDERS where ORDER_TOTAL = :total




Step 7: Select the set bind variables under the Test to test the query.


You can set the Bind variable :total’s value to 950 as in the cloud database and click on test to check the results.


In the above image you can see the data of the table DEMO_ORDERS where order total is 950.


Leave A Reply

Your email address will not be published. Required fields are marked *