My Oracle Support Banner

Oracle REST Data Services Demo - Create a REST Service - POST, PUT, DELETE (Doc ID 2626983.1)

Last updated on NOVEMBER 11, 2022

Applies to:

Oracle REST Data Services - Version 3.0 and later
Oracle SQL Developer - Version 4.0 and later
Oracle SQL Developer Web - Version 19.4 and later
Information in this document applies to any platform.

Goal

This is the second in a series of documents that provide a tutorial on creating ORDS based REST services for ORDS standalone. This demonstration is based on the example.oracle.hr demo and uses the same underlying database objects. While REST objects can be created via multiple interfaces (SQLPlus, SQL Developer, SQLcl, APEX, SQL Developer Web, etc.), this document focuses on the SQLPlus.

In the first document (<2626566.1> - Oracle REST Data Services Demo - Create a REST Service - GET), a schema was REST enabled, and a new module (rest.demo) with a GET handler. In this document we create POST, PUT and DELETE handlers.

 

While much of this information applies to other supported web servers, there are differences in the requirements and set up for these web servers. Where possible these differences will be noted. As a best practice, it is recommended that REST services be configured and tested in standalone ORDS prior to deploying in other supported web servers: Weblogic, Glassfish and Tomcat.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Create a POST Handler (Insert)
 Create a PUT Handler (Update)
 Create a DELETE Handler (Delete / Remove)
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.