Re: Help! How can I return a result set from a stored procedure.

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 ... Received on Fri Dec 29 1995 - 00:00:00 CET