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-25960: join index cannot be based on a temporary table

1 Answers  


PCC-02415: Cannot manipulate Object attributes in an OBJECT GET or SET

1 Answers  


RMAN-08008: channel string: starting full datafile backupset

1 Answers  


PLS-00405: subquery not allowed in this context

1 Answers  


ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

1 Answers  


NNL-01031: Name: string

1 Answers  


ORA-12570: TNS:packet reader failure

1 Answers  


ORA-12640: Authentication adapter initialization failed

1 Answers  


ORA-22370: incorrect usage of method string

1 Answers  


CLSR-00512: Invalid CAA trigger event type [string]

1 Answers  


LSX-00135: invalid min/max Occurs for <all> element, must be 0/1

1 Answers  


ORA-01715: UNIQUE may not be used with a cluster index

1 Answers  


Categories