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

create or replace procedure outin (p_cursor OUT types.cursorType,deptnum IN VARCHAR2)
is
begin
	open p_cursor for select * from EDepartment where deptid=deptnum;
end;
/