Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limit size when using Bulk Collect

456359Mar 26 2008 — edited Mar 27 2008
Hi,

What are the issues we might run into if we do not set the limit size when using bulk collect into a pl/sql table ?

Would not fetching all the records at one go be better from the performance point of view ?

Thanks for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2008
Added on Mar 26 2008
7 comments
760 views