Fetching a weak Ref Cursor
VeverkeApr 22 2010 — edited Apr 24 2010Hi 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.