| Maximum cursor overloaded problem [message #289385] |
Fri, 21 December 2007 03:03  |
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  |
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Maybe you should close your cursors when you no more use them.
Regards
Michel
[Updated on: Fri, 21 December 2007 03:39]
|
|
|
| Re: Maximum cursor overloaded problem [message #289392 is a reply to message #289387 ] |
Fri, 21 December 2007 03:50 |
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 |
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
 |
MarcS
Messages: 252
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
|
|
|
]
Members
Search
Help
Register
Login
Home
