Re: Can a stored procedure return rows?

From: Steve Gutterman <sgutterman_at_dreamworks.com>
Date: 1996/03/07
Message-ID: <4hng8q$p9n_at_argentina.it.earthlink.net>#1/1


In article <313DCCEE.76B8_at_mmacmail.jccbi.gov>, Russell_Foster_at_mmacmail.jccbi.gov says...
>
>Forgive the basic guestion....
>
>
>Can a stored procedure in Oracle 7.1 NT return a result set?
>
>I have used MS-SQL Server where a stored procedure can contain a select
>statement that can take parameters (much like a stored query in
>MS-Access).
>
>I have tried to create the same type of procedure in Oracle and it says
 I
>must use a cursor to have a select. Ok, but how to get the result set
>back to the calling application?
>
>Thanks for clearing this up for me.

No the current version of Oracle can not return a result set but the next version will. Received on Thu Mar 07 1996 - 00:00:00 CET

Original text of this message