SQL-02117: Invalid SQL Cursor usage: trying to OPEN an
OPENed cursor



SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor..

Answer / guest

Cause: An attempt was made to OPEN a cursor that was already
OPENed with MODE={ANSI|ANSI14|ANSI13}. An open cursor can be
re-OPENed only when MODE=ORACLE.

Action: When MODE={ANSI|ANSI14|ANSI13}, verify that a cursor
is not already OPENed before trying to OPEN it. Specify
MODE=ORACLE if an OPENed cursor is to be re-OPENed.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25963: join index must be created on tables

1 Answers  


ORA-01645: previous attempt to make read write is half complete

1 Answers  


NNL-00278: Maximum number of times a request can be reforwarded is now number

1 Answers  


ORA-29266: end-of-body reached

1 Answers  


PLS-00156: Null constraints not supported for object attributes.

1 Answers  






NNL-00216: Disabled auto-refresh for specified index number

1 Answers  


O2I-00128: Unable to write to the Java file

1 Answers  


RMAN-06455: point-in-time tablespace recovery requires Enterprise Edition

1 Answers  


ORA-12077: temporary updatable materialized view log does not exist

1 Answers  


ORA-29658: EXTERNAL NAME clause is not compatible with its supertype

1 Answers  


TNS-00238: Pump number @: string:

1 Answers  


PLS-01415: Use of aggregate value here

1 Answers  


Categories