Create REST Enabled SQL service references on the REST Enabled SQL page.
Before creating a REST enabled SQL reference, developers must complete the requirements described in "Before You Begin: REST Enabled SQL Service Requirements".
To create a REST Enabled SQL service reference:
You can also access the REST Enabled SQL page from Workspace Utilities. On the Workspace home page, click Workspace Utilities and then click REST Enabled SQL.
The URL must be in the format
http://host:port/ords/schema. You obtain the URL by enabling the target schema on the remote database to be accessed by running
ORDS.ENABLE_SCHEMA. To learn more, see "Before You Begin: REST Enabled SQL Service Requirements."
For Basic Authentication, enter the database user name. User names for Basic Authentication are converted to upper case. To include a case-sensitive user name, prefix it with the exclamation mark (
For OAuth2, enter the client ID. This information will not be encrypted.
Oracle Application Express tests the REST Enabled SQL service. If everything has been done correctly (that is, you have included the correct URL, schema name, and password), the Test REST Enabled SQL Service message appears as shown in the following illustration.
Description of the illustration GUID-A9DEE16A-B957-4BD1-B046-C31192ECB778-default.png