8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: clob_to_blob.sql
( Download Script )
CREATE OR REPLACE FUNCTION clob_to_blob (p_data IN CLOB) RETURN BLOB -- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/miscellaneous/clob_to_blob.sql -- Author : Tim Hall -- Description : Converts a CLOB to a BLOB. -- Last Modified: 26/12/2016 -- ----------------------------------------------------------------------------------- AS l_blob BLOB; l_dest_offset PLS_INTEGER := 1; l_src_offset PLS_INTEGER := 1; l_lang_context PLS_INTEGER := DBMS_LOB.default_lang_ctx; l_warning PLS_INTEGER := DBMS_LOB.warn_inconvertible_char; BEGIN DBMS_LOB.createtemporary( lob_loc => l_blob, cache => TRUE); DBMS_LOB.converttoblob( dest_lob => l_blob, src_clob => p_data, amount => DBMS_LOB.lobmaxsize, dest_offset => l_dest_offset, src_offset => l_src_offset, blob_csid => DBMS_LOB.default_csid, lang_context => l_lang_context, warning => l_warning); RETURN l_blob; END; /