Re: Returning resultsets from Oracle Stored procedures???

No.

You generally need to dump to a temp table then select out.

Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com

Kinder <kinder_at_sprynet.com> wrote in article <01bbe633$0c960720$ea87aec7_at_kinder.sprynet.com>...
> 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 Wed Dec 11 1996 - 00:00:00 CST