Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00719: only widening of attribute 'string' constraints is allowed

1 Answers  


ORA-07496: sppst: lm_post failed.

1 Answers  


ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

1 Answers  


ORA-12426: invalid audit option

1 Answers  


ORA-26663: error queue for apply process string must be empty

1 Answers  






ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"

1 Answers  


ORA-02155: invalid DEFAULT tablespace identifier

2 Answers  


ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


ORA-03278: duplicate ALLOCATE EXTENT option specification

1 Answers  


ORA-14321: cannot add/drop values to DEFAULT partition

1 Answers  


ORA-13756: Cannot update attribute "string".

1 Answers  


PCC-00079: ANSI requires colon on label in WHENEVER statement

1 Answers  






Categories