DBMS_LOB | Ontoor Solutions Blogs

Blob to Clob Using DBMS_LOB

Posted by - Ashish Sahay Feb 29, 2020 DBMS_LOB PLSQL

Create function to convert the blob content to clob 1CREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) 2 RETURN CLOB 3AS 4 l_chunk VARCHAR2 (32767); 5 l_position PLS_INTEGER := 1; 6 l_buffer_size PLS_INTEGER := 32767; 7 l_clob_text CLOB; 8BEGIN 9 -- Create temprary 10 DBMS_LOB.createtemporary …
Read More
CLOB to BLOB using PLSQL

Posted by - Ashish Sahay Feb 29, 2020 ORACLE PLSQL DBMS_LOB

Create function to convert the CLOB to BLOB 1CREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) 2 RETURN BLOB 3IS 4 /* 5Version 1 29-mar-2020 6*/ 7 l_blob_file BLOB; 8 l_lob_length PLS_INTEGER := DBMS_LOB.getlength (i_clob_text); 9 l_position PLS_INTEGER := 1; 10 l_buffer_size RAW (32767); 11BEGIN 12 …
Read More