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

CLSS-02203: unable to access voting device: string

1 Answers  


ORA-28292: No Domain Policy registered for Kerberos based authentication

1 Answers  


ORA-02844: Invalid value for the leave open flag

1 Answers  


NNL-00988: Non-authoritative NACKs received: number

1 Answers  


DRG-12401: invalid template: query within a loop

1 Answers  


ORA-39087: directory name string is invalid

2 Answers  


ORA-22288: file or LOB operation string failed string

1 Answers  


ORA-12546: TNS:permission denied

1 Answers  


RMAN-06548: connected to auxiliary database: string (DBID=string)

1 Answers  


ORA-01489: result of string concatenation is too long

1 Answers  


PLS-00111: end-of-file in comment

1 Answers  


ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

1 Answers  


Categories