Consuming ORDS Rest APIs using PL/SQL 1API End point : https://apex.oracle.com/pls/apex/ashish_portfolio/hr/test_emp 2 3Parameters : deptno, empno 4 5Method : GET 6 Without parameters 1Declare 2 l_clob CLOB; 3BEGIN 4 l_clob := APEX_WEB_SERVICE.make_rest_request( 5 p_url => …

Read More

Creating Rest API using ORDS ORDS APIs follows the Module, Template, Method. Now let see the Hierarchy of these. Module is top level container, it can contain set of templates . Template is at second level container can contain multiple Handlers. Handler is logical area where the purpose needs to define or what are …

Read More

Firstly we need to enable ORDS. Base url : <SERVER_URL>:<SERVER_PORT>/ords/ To hide the schema name from API endpoint we put any alias in url mapping pattern. 1BEGIN 2 ORDS.enable_schema( 3 p_enabled => TRUE, 4 p_schema => '<SCHEMA_NAME>', 5 p_url_mapping_type => 'BASE_PATH', …

Read More