List of Examples

• 2-1        Enabling the PL/SQL Function
• 2-2        Enabling the PL/SQL Procedure
• 2-3        Generating an Endpoint for the Stored Procedure
• 2-4        Package Procedure and Function Endpoints
• 2-5        Nested JSON Purchase Order with Nested LineItems
• 2-6        PL/SQL Handler Code Used for a POST Request
• 2-7        GET Handler Code using Oracle REST Data Services Query on Relational Tables for Generating a Nested JSON object
• 2-8        PL/SQL API Call for Creating a New test/:id Template and GET Handler in the demo Module
• 2-9        
• 2-10      ACL Rule in the Database
• 2-11      Setting the Duser.timezone Java Environment Variable in Standalone Mode
• 2-12      Setting the Duser.timezone Java Environment Variable in a Java Application Server
• 2-13      Setting Enabled for all Pools
• 3-1        Example
• 6-1        Example to Add Multiple Privileges
• 9-1        Example cURL Command
• 9-2        Binds in POST Request
• 9-3        Complex Bind in POST Request
• 9-4        Batch statements
• 9-5        Batch bind values
• 9-6        Oracle REST Data services Time Zone Set as Europe/London
• 9-7        PL/SQL Statement
• 9-8        Script
• 9-9        Query
• 9-10      Export
• 12-1      dads.conf file
• 12-2      ords_conf/databases/basic_auth/pool.xml
• 12-3      ords_conf/databases/basic_dynamic_auth/pool.xml
• 12-4      ords_conf/databases/custom_auth/pool.xml
• 12-5      ords_conf/databases/basic_auth/paths
• 12-6      ords_conf/databases/basic_dynamic_auth/paths
• 12-7      ords_conf/databases/custom_auth/paths
• 12-8       ords_conf/global/settings.xml
• 12-9      security.requestValidationFunction
• 12-10    procedure.preProcess
• 12-11    procedure.postProcess
• 12-12    Table upload
• 12-13    Procedure upload
• 12-14    Curl command for file upload