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

DRG-11856: FTP Server Doesn't Reply

1 Answers  


RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  


NNO-00307: invalid server name "string"

1 Answers  


ORA-36873: (XSTFDSC03) Column type must be specified explicitly.

1 Answers  


NNL-00221: Statistic counter logging interval is now string

1 Answers  






ORA-03203: concurrent update activity makes space analysis impossible

1 Answers  


NZE-29038: There are no matching certificates.

1 Answers  


NNL-00803: Queries received, type ALIAS: number

1 Answers  


ORA-06140: NETTCP: no such user

1 Answers  


PCC-02432: Cannot open an external LOB (BFILE) in READ WRITE mode

1 Answers  


ORA-07585: spdcr: $PARSE failure

1 Answers  


ORA-01045: user string lacks CREATE SESSION privilege; logon denied

1 Answers  


Categories