java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    maximum open cursors exceeded

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01000: maximum open cursors exceeded

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      T4CPreparedStatement.execute_maybe_describe
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
      8. oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
      8 frames