Originally Posted by omega1966 FETCH p_cursor BULK COLLECT INTO rec_array limit 1000; means it stops at 1000 FETCH p_cursor BULK COLLECT INTO rec_array limit 5000; stops at 5000. AFter that it is not progressing. That is the expected behavior from Oracle, what did you expect?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Forum Rules
Originally Posted by omega1966
Reply With Quote