Re: Getting recordset from stored procedure

Hello,

You have to use Cursors to do this. Then loop through the Cursor row by row.

Cursor c_Emp
IS
SELECT * FROM EMP; BEGIN FOR v_Data in c_Emp LOOP

    --Statements to process each row
END LOOP; Matthew MacFarland

Nobody wrote in message <356b7c21.35539833_at_nntp.ix.netcom.com>...
>I am a seasoned SQL Server stored procedure programmer. But in Oracle,
>is there a way to return record sets from a stored procedure? I wish
>to do something like this:
>
>create procedure get_data
>as
>begin
> select * from emp;
>end;
>/
>
>Please help, thanks.
Received on Wed May 27 1998 - 08:13:57 CDT