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