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

NNO-00801: Error: OCI_SUCCESS_WITH_INFO: string

1 Answers  


RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

1 Answers  


ORA-31033: Requested number of XML children string exceeds maximum string

1 Answers  


NZE-28859: SSL negotiation failure

1 Answers  


give full details of this ORA-12988: cannot drop column from table owned by SYS

8 Answers   Oracle,






ORA-09205: sfqio: error reading or writing to disk

1 Answers  


SQL*Loader-00120: Invalid _synchro option string

1 Answers  


KUP-02005: token too big

1 Answers  


ORA-32581: missing or invalid password

1 Answers  


ORA-00125: connection refused; invalid presentation

1 Answers  


ORA-23539: table "string"."string" currently being redefined

1 Answers  


ORA-06524: Unsupported option : string

1 Answers  


Categories