Return data from stored procedure

[amro]

CONNECT SCOTT/TIGER;

create or replace package types
as
type cursorType is ref cursor;
end;

create or replace procedure name_deptid ( p_cursor in out types.cursorType )
is
begin
open p_cursor for select dname, deptno from Dept;
end;

/*** How To retreive data as (Select * from Dept)***/

[Saii]

Hope this helps!!!

note: sys_refcursor (in oracle 9i)


create or replace procedure name_deptid ( p_cursor in out sys_refcursor)
is
begin
open p_cursor for select * from Dept;
end;