Create Or Replace package PKG_EMP
As
  Type T_Emp Is Ref Cursor;
  Procedure List_Emp(O_Emp T_Emp);
End;
/


Create Or Replace Package Body PKG_EMP
As
  Procedure List_Emp(O_Emp T_Emp)
  As
    SQL   VarChar2(500);
  Begin
    SQL := 'Select * From Employee';
    Open O_Emp For SQL ;
  End;
  
End;
/
