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

IMG-00821: area N queue clear failed

1 Answers  


ORA-01027: bind variables not allowed for data definition operations

1 Answers  


NNL-01067: Trace level: number

1 Answers  


ORA-01415: too many distinct aggregate functions

1 Answers  


ORA-40201: invalid input parameter string

1 Answers  






ORA-25445: invalid column number: string for table alias: string

1 Answers  


ORA-31153: Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"

1 Answers  


ORA-08196: Flashback Table operation is not allowed on AQ tables

1 Answers  


ORA-25266: didnt try to dequeue by message id. with the signature

1 Answers  


IMP-00008: unrecognized statement in the export file: string

1 Answers  


ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string

1 Answers  


ORA-01695: error converting rollback segment string to version 8.0.2

1 Answers  


Categories