Re: Can a stored procedure return rows?
Date: 1996/03/07
Message-ID: <4hn40p$j7q_at_inet-nntp-gw-1.us.oracle.com>#1/1
Oracle 7.2 with pl/sql 2.2.2 allows you to return cursor variables from stored procedures to the calling application. The pl/sql routine can open up any query and return the set to the invoking procedure by returning a cursor.
Russell Foster <Russell_Foster_at_mmacmail.jccbi.gov> wrote:
>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.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Thu Mar 07 1996 - 00:00:00 CET