stored procedure that returns a recordser

From: Gustavo Badauy <gbadauy_at_my-deja.com>
Date: 2000/07/27
Message-ID: <8lpvvi$vff$1@nnrp1.deja.com>#1/1

Hi,

I have some experience with MS SQL Server and It was very easy to create a stored procedure that returns a stored procedure and then get the results in the same way it would do retrieve a select statement.

How would I create the stored procedure in Oracle?

Let's say my stored procedure in MSSQL is like the one shown below

create procedure sp_test (name varchar(10)) begin
select birthday from Friends where FriendName like name end

I would easily run it as exec sp_test and it would return me the resultset. How would I do the same in Oracle, and how would I call it from a PL/SQL?

Thanks a lot

Gustavo Badauy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jul 27 2000 - 00:00:00 CDT