declare vclob clob; begin for c1 in (select text from all_source as of timestamp to_timestamp('02-05-2011 12:51:00', 'DD-MM-YYYY HH24:MI:SS') where name = 'PACKAGE NAME' and type = 'PACKAGE BODY' and owner = 'SCHEMA NAME') loop vclob :=vclob||c1.text; end loop; insert into tempTable (v_clob) values (vclob); end ;