Re: Returning resultsets from Oracle Stored procedures???

Unfortunately you can't do this in Oracle. The best you can do is return a single value using a stored function. If you need a record set returned, then you need to store the results in a temporary table and then select from it once you know that the stored procedure is successful. This is supposed to be available in some future version. Not sure if it is 7.3 or not.

Kasu Sista
Links Technology Corp.

>Are Oracle stored procedures able to return a result set to the calling
>applications(ie. a VB app)?
>
>I'm trying to retrieve rows without embedding or dynamically building the
>Select statement. I have used stored procedures to do this in SQL Server
>and Sybase, but I am having problems doing this in Oracle.
>
>This is an example of the SP that I'm trying to use. I am having errors
>when I try to create it.
>
>CREATE PROCEDURE SelEmp
>As
>BEGIN
> Select * From employee Order By last_name;
>END;
>
>Help me please!!!
>
>Lee
Received on Thu Dec 12 1996 - 00:00:00 CST