java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded Error Code: 604 Call: INSERT INTO CT_1 (JPS_ATTRS_ID, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?) bind => [3 parameters bound]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 2964514, 1 year ago
ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded Error Code: 604 Call: INSERT INTO CT_1 (JPS_ATTRS_ID, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?) bind => [3 parameters bound]
via eclipse.org by Unknown author, 2 years ago
Fail to convert to internal representation: Error Code: 17059 Call: DECLARE P_RECORDS_TARGET HR_DEPARTMENTS.DEPTTABTYPE; P_RECORDS_COMPAT HR_DEPARTMENT_TYPE := :1; FUNCTION EL_SQL2PL_1(aSqlItem HR_DEPARTMENT_ROW_TYPE) RETURN
via Stack Overflow by Ravi.Kumar
, 2 years ago
[OWLS][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. Error Code: 701 Call: SELECT DISTINCT t0.PRIMARY_KEY, t0.TOTAL_ACCRUAL, t0.TOTAL_ALLOCATED, t0.ALLOC_LIMIT, t0.APPL_END_ON, t0
via Coderanch by Kameyama Sato, 1 year ago
JZ0SB: Parameter index out of range: 1. Error Code: 0 Call: DECLARE x_TARGET INTEGER := :1; y_TARGET INTEGER := :2; z_TARGET VARCHAR(10) := :3; message_TARGET VARCHAR(255); BEGIN zzzSP(x=>x_TARGET, y=>y_TARGET, z=>z_TARGET, message
via Stack Overflow by Poyraz
, 2 years ago
Statement has already been closed Error Code: 0 Call: SELECT ID, FIRST_NAME, ISBLOCKED, LAST_NAME, MODIFIED, MSISDN, VERSION, OWNER_ID, CONTACT_ID FROM CONTACTS WHERE (OWNER_ID = ?) bind => [1 parameter bound] Query: ReadAllQuery(name
via Oracle Community by 772115, 1 year ago
SQL string is not Query Error Code: 17128 Call: WorkItem.findExpirable Query: DataReadQuery(sql="WorkItem.findExpirable")
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1620)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:964)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:633)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:149)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:134)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1845)
at org.eclipse.persistence.internal.sessions.AbstractSession.writesCompleted(AbstractSession.java:4300)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writesCompleted(UnitOfWorkImpl.java:5592)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:456)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.createEntry(JpsDBDataManager.java:2536)

Users with the same issue

Once, 2 months ago
Once, 9 months ago
10 times, 9 months ago
6 times, 1 year ago
2 times, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.