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 ;