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

SQL*Loader-00901: Error logging on to ORACLE:

1 Answers  


ORA-24032: object string exists, index could not be created for queue table string

1 Answers  


ORA-23326: object group "string"."string" is quiesced

1 Answers  


ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-12569: TNS:packet checksum failure

1 Answers  






ORA-01182: cannot create database file string - file is in use or recovery

1 Answers  


NNL-00271: Default domain is now "string"

1 Answers  


ORA-25126: Invalid name specified for BUFFER_POOL

1 Answers  


PLS-01405: Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

1 Answers  


ORA-09705: spcre: cannot initialize latch semaphore

1 Answers  


ORA-37003: (AWLISTALL01) number readers

1 Answers  


NNL-00546: Displays delete request statistics

1 Answers  


Categories