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!

Alternative to Cursors - Performance

575682May 20 2010 — edited Jan 10 2011
Hi,

I'm for the first time in a PL/SQL project and due to it I have a few doubts mainly about cursors.

Is it true that Cursors are bad in performance? IF yes what should I use instead ? Ref Coursors? Table types? What other options do I have?

Probably it will depend for what I need them... Im using a cursor to populate an array of objects.

Thanks,
JP
This post has been answered by William Robertson on May 20 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2011
Added on May 20 2010
9 comments
13,336 views