Home » Open Source » Programming Interfaces » Maximum cursor overloaded problem
Maximum cursor overloaded problem [message #289385] Fri, 21 December 2007 03:03 Go to next message
rony
Messages: 3
Registered: December 2007
Junior Member
Hi
Could anyone please help me out in the following prob->


2007/12/21 03:50:27 Rqst: main SQL State: 60000
2007/12/21 03:50:27 Rqst: main Msg: 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
ORA-01000: maximum open cursors exceeded

2007/12/21 03:50:27 Rqst: main Vendor Code: 604
2007/12/21 03:50:27 Stack Trace for
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
ORA-01000: maximum open cursors exceeded



at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:124)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:584)
at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:581)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2851)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:570)
at tools.dsi.LoggablePreparedStatement.executeQuery(LoggablePreparedStatement.java:207)


Problem coming from following Java code snippet->

TRACE.prtrace(5, TRACE.TR_DB, popis_query);
ResultSet rs = pstmt.executeQuery();
int counter=0;
while( rs.next() )
{
lata = rs.getString(1);
counter++;
}


Thanks in appreciation..Please help me out ASAP..
Re: Maximum cursor overloaded problem [message #289387 is a reply to message #289385] Fri, 21 December 2007 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58520
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you should close your cursors when you no more use them.

Regards
Michel

[Updated on: Fri, 21 December 2007 03:39]

Report message to a moderator

Re: Maximum cursor overloaded problem [message #289392 is a reply to message #289387] Fri, 21 December 2007 03:50 Go to previous messageGo to next message
rony
Messages: 3
Registered: December 2007
Junior Member
All the prepared statement, conn, and result set are closed...
No problem there
Re: Maximum cursor overloaded problem [message #289393 is a reply to message #289392] Fri, 21 December 2007 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 58520
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Max open cursor error is raised when session opened (and did not close) more cursors than allowed.
So
1/ check your open_cursors parameter
2/ verify your code once more

Regards
Michel
Re: Maximum cursor overloaded problem [message #289395 is a reply to message #289393] Fri, 21 December 2007 03:57 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Quote:

2/ verify your code once more


This means : check ALL of your code. The problem - cursors not closed - could come from somewhere else
Previous Topic: Executing a Stored Procedure with visual basic 6
Next Topic: Connection breaks after Alter System flush Shared Pool
Goto Forum:
  


Current Time: Wed Jul 23 15:33:15 CDT 2014

Total time taken to generate the page: 0.12416 seconds