SQL-02122: Invalid OPEN or PREPARE for this database connection



SQL-02122: Invalid OPEN or PREPARE for this database connection..

Answer / guest

Cause: An attempt was made to execute an OPEN or a PREPARE
statement using a cursor that is currently open for another
database connection and, therefore, cannot be used for this
connection.

Action: Close the cursor to make it available for this
connection or use a different cursor for this connection.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Oracle Errors Interview Questions

PCC-00121: Arrays of VARCHAR pointers are not supported

1 Answers  


QSM-00507: no dimensions could be found

1 Answers  


ORA-26686: cannot capture from specified SCN

1 Answers  


ORA-33460: (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.

1 Answers  


DRG-12220: a valid tag must be provided

1 Answers  






PCB-00223: Undeclared variable "string"

1 Answers  


ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.

1 Answers  


ORA-31634: job already exists

1 Answers  


ORA-36772: (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  


ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file

1 Answers  


NID-00501: ----------------------------------------------------

1 Answers  


PLS-01468: The first argument of the like-predicate must be a column of type character string

1 Answers  


Categories