require help

microsoft.public.dotnet.framework.adonet

19 May 2006 9:20 PM

shree

I need to retreive data from different tables say tab1,tab2,tab3 for
each id value (tab4.id)
in tab4 and get the whole result set into refcursor which is to be
passed as an out parameter in a stored procedure and further to a .net
application which does not support oracle datatypes like associative
array or record. So i need to get the results into refcursor only.

I have a procedure written which does retrieve data from different
tables and have used static cursors to do this. But i'm not knowing how
to get the whole resultset into refcursor.

Could someone please help me.

thanks,
Nagashree