Posted inAPEX

APEX Page Group

Page groups are very helpful for developers to manage application pages. Developer can use Page Groups to club the similar kind of Pages. These groups give the a centralized management…
February 29, 2020
Posted inORACLE PLSQL

CLOB to BLOB using PLSQL

Create function to convert the CLOB to BLOB Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) RETURN BLOB IS /* Version 1 29-mar-2020 */ l_blob_file BLOB;…
February 29, 2020
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
Posted inAPEX

Clob to Blob Using APEX Web Service

CLOBBASE642BLOB Function This function is used to convert Clob to base64Blob. Syntax APEX_WEB_SERVICE.CLOBBASE642BLOB ( p_clob IN CLOB) RETURN BLOB; Example declare l_clob CLOB; l_blob BLOB; l_blob_2 BLOB; begin SELECT BLOB_CONTENT…
February 29, 2020
Posted inAPEX

Use of $s $x $v

$x $x is used to find the control on the DOM meaning looking for any item available on DOM. If the control is found then it returns the dom of the…
February 29, 2020
Posted inORACLE

Blob to Clob Using DBMS_LOB

Create function to convert the blob content to clob Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER :=…
February 29, 2020
Posted inORACLE

ORA-06533: Subscript beyond count

ORA-06533: Subscript beyond count Cause: An in-limit subscript was greater than the count of a varray or too large for a nested table. Action: Check the program logic and explicitly…
February 26, 2020