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.
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
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:
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.
When providing the URL for the target schema in Oracle Application Express, do not append
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: