Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> stored procedure that returns a recordser
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
![]() |
![]() |