Re: Is it possible to return mulitple columns,rows from a stored procedure?

It's hard to give you a complete answer because you didn't tell us which languages you're using. I do this all the time from ProC calling a PL/SQL stored procedure. I call a stored procedure which opens a REF CURSOR and returns it to the ProC module. The ProC module then FETCHES the rows, then CLOSEs the REF CURSOR. It works well, and allows me to redefine the query w/out recompiling the ProC program. Good luck.

Paul Cluiss
Richardson, Texas

kray_at_gabrielcom.net wrote:

> Is it possible to return multiple rows/columns from a stored
> procedure...or do you have to do a function?
>
> We've been able to return one column from a function, but would like to
> be able to return multiple columns and rows...there has got to be a way
> to do this...we've done something similar in Sybase I believe.
>
> (obviously and oracle newbie)
>
> Thanks for any help.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 11 2000 - 12:00:00 CST