Oracle Error PLS-00994: Cursor Variables cannot be declared as part of a package

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.