Create function to convert the CLOB to BLOB Now try with clob to blob conversion You might Like Read more
BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: APEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB; Example : declare l_clob CLOB; l_blob BLOB; begin SELECT BLOB_CONTENT INTO l_BLOB FROM APEX_APPLICATION_FILES WHERE name = :P1_FILE_NAME; l_CLOB := apex_web_service.blob2clobbase64(l_BLOB);... Read more
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
Create function to convert the blob content to clob Now try with Blob content to Clob conversion Read more