1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

PLS-00994: Cursor Variables cannot be declared as part of a
package

Question Posted / guest

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2296

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2238

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1247

RMAN-05017: no copy of datafile number found to recover

1894

ORA-26082: load of overlapping segments on table string.string is not allowed

1386




ORA-26028: index string.string initially in unusable state

3412

ORA-26084: direct path context already finished

1492

ORA-26032: index string.string loading aborted after string keys

1662

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1758

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2634

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2310

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2867

ORA-16627: No standby databases support the overall protection mode.

3564

ORA-26079: file "string" is not part of table string.string

1528

ORA-26095: unprocessed stream data exists

2823