a loop within a loop....
604514Feb 4 2008 — edited Feb 5 2008Hello, I want to make a loop inside a loop, I have this code.
cursor c1 is select * from DYN_INDEX_PRICES;
BEGIN
delete from BenchmarkPosition_new;
counter := 1;
for tupel in c1 loop
cursor c2 is select * from tupel.INDEX_TABLE_NAMES;
for tupel in c2 loop
more code ....
then
end loop
end loop etc.
But this code seems not be ok according to the compiler...
Any help much appreciated.
best regards
Harald