Skip to Main Content

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!

Fetching a weak Ref Cursor

VeverkeApr 22 2010 — edited Apr 24 2010
Hi all,
My program calls a SP that returns a REF CURSOR I need to read. What are the ways I can achieve this ?
According to what what I found so far in my googling/searching forums,
I can loop over the cursor or fetch it to a collection via bulk collect - but when it is a strongly typed ref cursor (linked to a db catalog or user defined type).
What about a weakly typed REF CURSOR ? I did not find help on how to read it.
Is it possible to loop over/fetch the whole cursor to a collection to a "generic" buffer variable ?
I even tried creating a collection typed with the structure my ref cursor returns, but am not sure I am succeeding (got an ORA-06502:PL/SQL: numeric or value error: Bulk Bind: Truncated Bind)

Any help highly appreciated.
Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2010
Added on Apr 22 2010
11 comments
5,056 views