Re: Help! How can I return a result set from a stored procedure.
From: Maruf Ahmed <muppa1_at_osf1.gmu.edu>
Date: 1996/01/02
Message-ID: <30E9902A.D18_at_osf1.gmu.edu>#1/1
Date: 1996/01/02
Message-ID: <30E9902A.D18_at_osf1.gmu.edu>#1/1
Vivekanandhan Raja wrote:
>
> You cannot pass result sets back from Store procs in Oracle (i guess
> SQL Server let's u do that?). Now comes the question of where u are
> attempting to the retrieve the result from i.e. the type of interface. If
> it uses PRO*C then all you need is to declare your SP as taking array
> args. one arg per column of the result set. and two additional args for
> actual # of rows returned and the total # of rows retrieved ...
Thanks. I am using Visual Basic. Can you give me the syntax of
accomplishing what you described in VB. Also, any insights on
how I can do an outer join with a cursor in a stored procedure.
Thanks.
:Maruf
Received on Tue Jan 02 1996 - 00:00:00 CET