Oracle Error Message
PLS-00994: Cursor Variables cannot be declared as part of a package
Reason for the Error
An attempt was made to declare a cursor variable in a package specification, which is not allowed. Although REF CURSOR types can be defined in a PL/SQL block, subprogram, or package, cursor variables can be declared only in a block or subprogram.
Solution
Move the cursor variable declaration into a PL/SQL block or subprogram.