PLS-00994: Cursor Variables cannot be declared as part of a
package
- 1 Answers
- 4648 Views
- CTS, I also Faced
- E-Mail Answers
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 |
ORA-21503: program terminated by fatal error
ORA-01771: illegal option for a clustered table
ORA-01077: background process initialization failure
ORA-14329: domain index [sub]partitions cannot be renamed in this clause
KUP-04022: field start is before start of record
ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
RMAN-06588: number of patterns (number) to DB_FILE_NAME_CONVERT should be even
ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed
ORA-13197: element string.string.string is out of range
ORA-22131: hexadecimal string length is zero
KUP-00554: error encountered while parsing access parameters
TNS-00010: Error while flushing NS context
Oracle Errors 
