Posted inAPEX

BLOB to CLOB using APEX_WEB_SERVICE

BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: Copy CodeCopiedUse a different BrowserAPEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB; Example : Copy CodeCopiedUse a different Browserdeclare…
February 29, 2020
Posted inAPEX ORDS

Getting into ORDS

Firstly we need to enable ORDS. Base url : <SERVER_URL>:<SERVER_PORT>/ords/ To hide the schema name from the API endpoint we put any alias in the url mapping pattern. Copy CodeCopiedUse a different…
February 29, 2020
Posted inAPEX ORDS

Restful API using ORDS

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…
February 29, 2020
Posted inAPEX ORDS

Consuming ORDS Rest APIs using PL/SQL

Consuming ORDS Rest APIs using PL/SQL API End point : https://apex.oracle.com/pls/apex/ashish_portfolio/hr/test_emp Parameters : deptno, empno Method : GET Without parameters Copy CodeCopiedUse a different BrowserDeclare l_clob CLOB; BEGIN l_clob :=…
February 29, 2020