Du hast recht. In meinem Code wird eine Funktion aufgerufen, die ich hier nachliefere:

create or replace

function clob2blob (p_clob in clob )

return blob

is

v_blob blob;

v_offset integer := 1;

v_length integer;

v_amount binary_integer;

v_buffer varchar2(32767);

v_rawbuffer raw(32767);

c_read_chunksize constant binary_integer := 10000;

begin


dbms_lob.createtemporary(v_blob,true);

v_length := dbms_lob.getlength(p_clob);

v_offset := 1;

while (v_offset < v_length) loop

v_amount := c_read_chunksize;

dbms_lob.read( p_clob, v_amount, v_offset, v_buffer );

v_rawbuffer := utl_raw.cast_to_raw( v_buffer );

dbms_lob.write( v_blob, v_amount, v_offset, v_rawbuffer );

v_offset := v_offset + c_read_chunksize;

end loop;

return v_blob;

end;

--
Best regards,
Carsten mailto:carsten.cerny@cc13.com
My blog [cc13.com]