Skip to content

Instantly share code, notes, and snippets.

@AmrAbdeen

AmrAbdeen/Configuring_RESTful_Services

Created September 1, 2015 08:55
Show Gist options
  • Save AmrAbdeen/fcdb429f2710d37ee14d to your computer and use it in GitHub Desktop.
Save AmrAbdeen/fcdb429f2710d37ee14d to your computer and use it in GitHub Desktop.
Download ZIP
How configure RESTful Services in Oracle Application Express. source: https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29159
Raw
Configuring_RESTful_Services
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment