maximum open cursors exceeded (with Stored Procedure)

From: Pirola Davide (davide.pirol..tin.it)
Date: Fri Feb 04 2005 - 07:00:23 EST

  • Next message: Andrus Adamchik: "Re: maximum open cursors exceeded (with Stored Procedure)"

    Hi,
    i have found this error when i execute my code in a loop.
    I must close open cursors?
    Where i can make this?

    Thank's
    Davide

    -------------------------------------------------------------------------------------------
    INFO QueryLogger: *** error.
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded
    ORA-06512: at "AUTHORIZATION_MANAGER.AUTHORIZATION", line 926
    ORA-06512: at line 1

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
            at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152)
            at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876)
            at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:685)
            at org.objectstyle.cayenne.access.DataNode.runStoredProcedure(DataNode.java:640)
            .....
    -------------------------------------------------------------------------------------------

    This archive was generated by hypermail 2.0.0 : Fri Feb 04 2005 - 06:59:39 EST