Oracle JDBC problem( ORA-00604, ORA-01000)

[meerah...@my-deja.com]

Hi,

Urgent help needed....I am getting the following trace when I am trying
to update the ORACLE 7 (NT version) database from java program.
I have the open_cursors parameters to 2000.

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level
1
ORA-01000: maximum open cursors exceeded

at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch
(TTC7Protocol.java:649
)
at oracle.jdbc.driver.OracleStatement.doExecuteOther
(OracleStatement.jav
a:761)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch
(OracleStatement
.java:803)
at oracle.jdbc.driver.OracleStatement.doExecute(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(Compiled Code
)
at oracle.jdbc.driver.OracleStatement.executeUpdate
(OracleStatement.java
:1194)
at com.solix.tangoUtil.RecToProp.writeToTable
(RecToProp.java:320)
at com.solix.workflow.WfFlow.serializeMe(WfFlow.java:479)
at com.solix.admin.WfFlowCanvas.serializeMe
(WfFlowCanvas.java:350)
at com.solix.admin.WfDrawingArea.serializeMe(Compiled Code)
at com.solix.admin.WfEditor.updateDB(WfEditor.java:731)

Thanks in advance
Meerah

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.