API | Ontoor Solutions Blogs

Get Images from ORACLE REST Web Service

Posted by - Ashish Sahay Apr 6, 2020 APEX PLSQL SQL API

How to get Images from ORACLE REST Web Service ? Oracle REST APIs provides the feature of media resource, here we can write the query with two columns content type and image blob. While i was trying to implement i saw tweaks, the query has to be in below format only. 1SELECT 'content_type', 2 column 3 FROM . . …

Consuming ORDS Rest APIs using PL/SQL

Posted by - Ashish Sahay Feb 29, 2020 APEX PLSQL ORDS API

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 => …

Restful API using ORDS

Posted by - Ashish Sahay Feb 29, 2020 APEX ORDS API

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 …