Re: How to return RESULTSET from Oracle Stored Procedure?

From: Troy Fruetel <Troy_Fruetel_at_connects.com>
Date: 1997/11/12
Message-ID: <64cpv9$ouj$1@news3.mr.net>#1/1

You must use the Oracle data type CURSOR.

You need to select the results INTO something (i.e. SELECT column INTO :variable FROM TABLE)

Troy Fruetel
[Connect]

Vladimir Agajanov wrote in message <01bcef86$e689d4e0$b4320a0a_at_vgawks001>...
>Hello,everybody!
>
>I really do not know where to look for the answer that I have about Oracle.
>
>THe question is: Why it is not possible to execute SELECT * FROM TABLE
>inside the body of Sored procedure?
>From Sybase I know that stored procedure accepts IN, OUT, IN OUT parameters
>but it also has a resultset. Then how can I achieve the same resultset on
>the client side from Oracle stored procedure?
>
>Any suggestions will be greately appreciated!
>
>Vladimir
Received on Wed Nov 12 1997 - 00:00:00 CST