PLS-00994: Cursor Variables cannot be declared as part of a
package
- 1 Answers
- 4615 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-32810: foreign queue string is not registered
ORA-19909: datafile string belongs to an orphan incarnation
NNL-00292: Scheduled statistic counters to be reset in string
ORA-34358: (MXDSS14) number other users reading
QSM-02067: no partition key or PMARKER or join dependent expression in select list
ORA-26033: Direct path operation not supported on table with encrypted colum
ORA-02838: Unable to arm signal handler for the alarm signal
CLSR-00517: Failed to register a service name
ORA-01150: cannot prevent writes - file string has online backup set
PLS-00400: different number of columns between cursor SELECT statement and return value
TNS-01100: TNS returned error number when attempting to start the listener
KUP-02000: wrong message file version (msg number not found)
Oracle Errors 
