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


SQL-02117: Invalid SQL Cursor usage: trying to OPEN an
OPENed cursor



SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor..

Answer / guest

Cause: An attempt was made to OPEN a cursor that was already
OPENed with MODE={ANSI|ANSI14|ANSI13}. An open cursor can be
re-OPENed only when MODE=ORACLE.

Action: When MODE={ANSI|ANSI14|ANSI13}, verify that a cursor
is not already OPENed before trying to OPEN it. Specify
MODE=ORACLE if an OPENed cursor is to be re-OPENed.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00933: Specified file string not part of database

1 Answers  


ORA-29701: unable to connect to Cluster Manager

1 Answers  


ORA-01212: MAXLOGMEMBERS may not exceed string

1 Answers  


NID-00370: Change database ID of database string? (Y/[N]) =>

1 Answers  


ORA-12548: TNS:incomplete read or write

1 Answers  






ORA-14551: cannot perform a DML operation inside a query

1 Answers  


ORA-12319: database (link name string) is already open

1 Answers  


PLS-00552: flexible character set is not allowed on component element

1 Answers  


ORA-29658: EXTERNAL NAME clause is not compatible with its supertype

1 Answers  


ORA-12214: TNS:missing local communities entry in TNSNAV.ORA

1 Answers  


ORA-25240: message ID and dequeue condition/correlation ID specified in dequeue options

1 Answers  


ORA-02096: specified initialization parameter is not modifiable with this option

1 Answers  






Categories