Re: Returning resultsets from Oracle Stored procedures???

From: Lior Kogot <gorgor_at_netvision.net.il>
Date: 1996/12/14
Message-ID: <01bbea0c$69d69bc0$36f8cbc7@gorgor>#1/1

hi,

what you can do is to work with stored package in Oracle 7.3 that allow you to return more then one row.

Lior.

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 Sat Dec 14 1996 - 00:00:00 CST