Define Single Level
uSpecify in NORMAL code what you need:
declare
u type rows_t is table of
REFERENCE%rowtype;
u v_rows rows_t;
ubegin
u select * bulk collect into v_rows
u from REFERENCE t where ADDRESS_ID in
(select id from table (cast (:1 as
id_tt)));
for i in v_rows.first..v_rows.last loop
select object_Seq.nextval into v_new_id
from dual;
…
u v_rows(i).REF_ID:=v_new_id;
u v_rows(i).ADDRESS_ID:=
u
clone_pkg.v_Pair_t(v_rows(i).ADDRESS_ID);
u end loop;
u forall i in v_rows.first..v_rows.last
insert into REFERENCE values
v_rows(i);
…
end;