Blob to Clob Using DBMS_LOB

Create function to convert the blob content to clob CREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER := 1; l_buffer_size PLS_INTEGER := 32767; l_clob_text CLOB; BEGIN -- Create temprary DBMS_LOB.createtemporary (l_clob_text, TRUE); FOR i …

CLOB to BLOB using PLSQL

Create function to convert the CLOB to BLOB CREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) RETURN BLOB IS /* Version 1 29-mar-2020 */ l_blob_file BLOB; l_lob_length PLS_INTEGER := DBMS_LOB.getlength (i_clob_text); l_position PLS_INTEGER := 1; l_buffer_size RAW (32767); BEGIN DBMS_LOB.createtemporary …