Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-11125: invalid format of existing log file string

1 Answers  


ORA-37012: (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.

1 Answers  


ORA-15057: specified size of string MB is larger than actual size of string MB

1 Answers  


ORA-30510: system triggers cannot be defined on the schema of SYS user

1 Answers  


ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS

1 Answers  






ORA-24403: error occured while trying to destroy the connection pool

1 Answers  


ORA-06900: CMX: cannot read tns directory

1 Answers  


PLS-00526: A MAP or ORDER function is required for comparing objects in PL/SQL.

1 Answers  


TNS-04007: Internal error number.

1 Answers  


ORA-28174: Kerberos ticket not provided by proxy

1 Answers  


PCC-00111: SQLCHECK value in EXEC ORACLE statement exceeds command line value

1 Answers  


NNL-00204: Cancelled shutdown

1 Answers  






Categories