Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to return RESULTSET from Oracle Stored Procedure?
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
![]() |
![]() |