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!

How to get the row count from a weak cursor (SYS_REFCURSOR).

763899Sep 7 2010 — edited Sep 7 2010
Hi Gurus,

Is it possible to get the row count from a weak cursor like SYS_REFCURSOR? Basically i just need to know whether the rowcount exceeds a variable value (e.g. 100K).

Also how do we BULK COLLECT the weak cursors into a collection if the structure of the columns in the cursor us unknown? I want to be able to fetch data in blocks.

Rgds.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Sep 7 2010
18 comments
10,356 views