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-31650: timeout waiting for master process response

1 Answers  


ORA-00825: cannot set db_block_buffers if sga_target set

1 Answers  


DRG-50800: failed to open cursor

1 Answers  


ORA-30507: normal triggers cannot be based on a schema or a database

1 Answers  


RMAN-08030: allocated channel: string

1 Answers  






ORA-16092: dependent archive log destination is not active

1 Answers  


SQL*Loader-00417: SQL string (on column string) not allowed in direct path.

1 Answers  


RMAN-20504: corruption list not found in recovery catalog

1 Answers  


ORA-07845: sllfcl: LIB$FREE_VM failue

1 Answers  


ORA-06592: CASE not found while executing CASE statement

1 Answers  


DRG-10310: servers were shutdown before processing request

1 Answers  


LCD-00206: positional parameter entered after keyword [string]

1 Answers  


Categories