Re: stored procedure that returns a recordser

This is a FAQ, it is asked and answered at least once week. I already said, I wouldn't answer it anymore
However, yet another time

http://x76.deja.com/getdoc.xp?AN=648732594&CONTEXT=964724697.1338114065&hitn um=4

If you have access to www.deja.com (and as you are posting from deja that is *very* likely) please use the search function before you start posting. It might answer your question rightaway.

Regards,

Sybrand Bakker, Oracle DBA

"Gustavo Badauy" <gbadauy_at_my-deja.com> wrote in message news:8lpvvi$vff$1_at_nnrp1.deja.com...
> 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