declare
i number;
...
begin
...
open c_city( pc1.arb_ord_nr, pc1.arb_ord_zae );
loop
fetch c_city into pCity;
exit when c_city%notfound;
for i in 1..pCity.quantity loop
/* -- add one label per city cursor row */
insert into labels
( sessionid, arb_ord_nr, c_number, tl_fam, tl_atn, c_type, dat_neu )
values
( sid, pCity.arb_ord_nr, i, null, null, sType, sysdate );
commit;
end loop;
end loop;
close c_city;
No comments:
Post a Comment