create or replace package temppkg
is
type mytable is ref cursor;
procedure Get_Template(cur_mytable out mytable);
end;
/
create or replace package body temppkg
is
procedure Get_Template(cur_mytable out mytable)
is
begin
open cur_mytable for select * from ZBGL_CW_HISMX;
end Get_Template;
end temppkg;
/