Limit in cursor with pl/sql table
659159Oct 1 2008 — edited Oct 6 2008Hi,
I have a cursor from a table with 14 rows.
I am putting the rows into a pl/sql table using limit as follows:
open c_type;
loop
fetch c_type bulk collect into my_tab limit n;
exit when c_type%notfound;
end loop;
close c_type;
when I give n>14 then it's OK.But when i give n=14 then it gives zero reocord.
Interestingly,
when n is decresed from 14 to 8, the count increased from 0 to 6 and when n=7 count is again 0.
could any one tell me what's going on here?
Thanks,
Souvik