Cacher is the code snippet organizer for pro developers

Configuring RESTful Services
To configure RESTful Services in Oracle Application Express:

Change your working directory to the apex directory where you unzipped the installation software.

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

On Windows:
SYSTEM_DRIVE:\ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

On UNIX and Linux:
$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

Run apex_rest_config.sql. For example:

@apex_rest_config.sql
When Prompted, enter a password for the APEX_LISTENER and APEX_REST_PUBLIC_USER accounts.

When configuring RESTful Services in Oracle Application Express, it creates two new database accounts.

APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.

APEX_REST_PUBLIC_USER - The account used when calling RESTful Services definitions stored in Oracle Application Express.