CLOB to BLOB using PLSQL

Create function to convert the CLOB to BLOB Now try with clob to blob conversion You might Like Read more

BLOB to CLOB using APEX_WEB_SERVICE

BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: Example : References: apex_web_service.blob2clobbase64 Read more

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 INTO l_BLOB FROM APEX_APPLICATION_FILES WHERE filename = 'APEX_ENHANCED_LOV_ITEM.plb'; -- Blob... Read more

Blob to Clob Using DBMS_LOB

Create function to convert the blob content to clob Now try with Blob content to Clob conversion Read more