CREATE OR REPLACE PACKAGE GetPermits AS
Type RetCursor Is Ref Cursor;
Procedure ReturnCursor(pCursor OUT RetCursor,c_mask IN char);
END;
/
SHO ERR
CREATE OR REPLACE PACKAGE BODY GetPermits AS
Procedure ReturnCursor(pCursor OUT RetCursor, c_mask in char) is
Begin
open pCursor for select * from permits where permit_num = c_mask;
End;
END;
/
SHO ERR
Works in SQL Plus and Work Sheet...
Cheers