Open and Closing CLOBS

Example

DECLARE
   l_clob        CLOB ;
BEGIN
   -- OPEN CLOB       
   dbms_lob.createTemporary( l_clob, true );
   dbms_lob.open( l_clob, dbms_lob.lob_readwrite );
/*
   BUSINESS PROCESSING
*/
   -- CLOSE CLOB
   dbms_lob.close( l_clob );
   dbms_lob.freeTemporary( l_clob );
END ;