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-02216: tablespace name expected

2 Answers  


ORA-24806: LOB form mismatch

2 Answers  


ORA-38705: Expected block size string does not match string in log header.

1 Answers  


ORA-01584: unable to get file size of controlfile to be backed up

1 Answers  


PCC-02414: This attribute does not exist in the specified Object

1 Answers  






QSM-01060: illegal subquery in the HAVING clause

1 Answers  


KUP-04047: error parsing record from external data source

1 Answers  


DRG-11856: FTP Server Doesn't Reply

1 Answers  


ORA-19004: Duplicate XMLType OBJECT RELATIONAL storage option

1 Answers  


NNL-01042: Data streams answered by server: number

1 Answers  


ORA-09794: szrbuild: length of role name is greater than buffer.

1 Answers  


ORA-06009: NETASY: dialogue filename too long

1 Answers  


Categories