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

ORA-03124: two-task internal error

1 Answers  


ORA-22897: no scope clause specified for user-defined REF column "string"

1 Answers  


ORA-25259: cannot specify protocol for agent

1 Answers  


TNS-01062: The db subagent is already running.

1 Answers  


ORA-03277: invalid SIZE specified

1 Answers  


SQL*Loader-00941: Error during describe of table string

1 Answers  


ORA-27039: create file failed, file size limit reached

1 Answers  


IMG-00899: signature cannot be generated

1 Answers  


ORA-19657: cannot inspect current datafile string

1 Answers  


ORA-32127: REFs do not belong to any connection

1 Answers  


ORA-01691: unable to extend lob segment string.string by string in tablespace string

1 Answers  


ORA-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


Categories