create or replace function sp_ListPlan return types.cursortype
as
l_cursor types.cursortype;
begin
open l_cursor for select planid, planname from plan;
return l_cursor;
end;
/