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!

Select query on REF CURSOR

711126Aug 28 2010 — edited Sep 19 2010

Hi all,

I am trying see if we can use LINQ like functionality to query a ref cursor resultset. I have about 50 procedures( as part of 12 packages) which send the ref cursor output to a front end application when called individually. Now I need to create a procedure to get only specified records from each of these 50 ref cursors and output it to another ref curosr.

In other words how can I use the following

select col_2 from pkg_abc.pro_ref_cursor_out(arg1, arg2...) where col_1 = 'X':

I am not inclined to use a fetch as I foresee performance issues?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2010

Added on Aug 28 2010

13 comments

6,394 views