SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a
CLOSEd cursor



SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier

1 Answers  


NNL-00294: No entries found

1 Answers  


ORA-02245: invalid ROLLBACK SEGMENT name

1 Answers  


IMG-00824: fail queue pop failed

1 Answers  


ORA-27069: attempt to do I/O beyond the range of the file

1 Answers  






ORA-32341: The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"

1 Answers  


ORA-25156: old style outer join (+) cannot be used with ANSI joins

1 Answers  


ORA-25408: can not safely replay call

2 Answers  


ORA-13278: failure to convert SRID to native format

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


PLS-00105: at most one forward declaration of type 'string' is permitted

1 Answers  


LSX-00206: substitution for element "~S" is disallowed

1 Answers  


Categories