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



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

Answer / guest

Cause: 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.

Action: Move the cursor variable declaration into a PL/SQL
block or subprogram.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00502: unable to open data file 'string' for field string table string

1 Answers  


DRG-11439: index name length exceeds maximum of string bytes

1 Answers  


RMAN-06517: KEEP option is not supported for archive log backups

1 Answers  


TNS-00071: where <command> is one of following:

1 Answers  


ORA-30108: invalid positional parameter value 'string'

1 Answers  






PCC-02332: attempted to redefine SQL identifier

1 Answers  


ORA-02776: Value for request done signal exceeds maximum

1 Answers  


ORA-23318: a ddl failure has occurred

1 Answers  


ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 Answers  


QSM-00803: The STORAGE_CHANGE parameter value string cannot be zero or negative for partial workloads.

1 Answers  


ORA-10644: SYSTEM tablespace cannot be default temporary tablespace

1 Answers  


ORA-31672: Worker process string died unexpectedly.

1 Answers  


Categories