Before You Begin: REST Enabled SQL Service Requirements
Prior to creating a REST enabled SQL reference, developers must complete these requirements.
Complete the following requirements before creating REST enabled SQL reference:
-
Set up a remote Oracle database.
-
On the remote Oracle database, install Oracle REST Data Services (ORDS) release 17.3 or later.
Tip:
This installation is completely independent from the Oracle REST Data Services used as the Oracle Application Express web server
-
Configure and enable the REST Enabled SQL service feature. See “Configuring REST-Enabled SQL Service Settings” in Oracle REST Data Services Installation, Configuration, and Development Guide.
-
Activate REST Enabled SQL for the target schema on the remote database to be accessed by running
ORDS.ENABLE_SCHEMA
.Log in to the database schema to be enabled for REST Enabled SQL using a "classic" client and execute the following:
begin ords.enable_schema; end; / commit /
The REST Enabled SQL service is then available with a URL in the following format:
http://host:port/ords/schema
-
host
is the name of the system where Oracle REST Data Services is installed. -
port
is the port number assigned when configuring Oracle REST Data Services. In a default installation, this number is 8080. -
ords
is the service name defined when configuring Oracle REST Data Services. -
schema
is the target schema.
Tip:
When providing the URL for the target schema in Oracle Application Express, do not append /_/sql;
.
You will use a URL using the above format when creating the REST Enabled SQL service reference in Oracle Application Express.
For example, the following is a REST Enabled SQL service for the scott_obe
schema with ORDS running in standalone mode:
http://server.example.com:8080/ords/scott_obe
Parent topic: Managing REST Enabled SQL References