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-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE

1 Answers  


DRG-11712: multiple Broader Terms for term string

1 Answers  


ORA-01983: invalid auditing option for DEFAULT

1 Answers  


ORA-01103: database name 'string' in controlfile is not 'string'

4 Answers  


ORA-16000: database open for read-only access

1 Answers  






PLS-00321: expression 'string' is inappropriate as the left hand side of an assignment statement

1 Answers  


PCC-00085: Error writing to file string

1 Answers  


ORA-02899: smscre: Cannot create SGA with Extended Shared Memory feature

1 Answers  


ORA-12170: TNS:Connect timeout occurred

1 Answers  


PLS-00233: function name used as an exception name in when clause

1 Answers  


CLSR-00514: Unable to locate PMON [pid=string]

1 Answers  


ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

2 Answers  


Categories