OraFAQ Forum: Programming Interfaces » Maximum cursor overloaded problem

Home » Open Source » Programming Interfaces » Maximum cursor overloaded problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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..

Report message to a moderator

Re: Maximum cursor overloaded problem [message #289387 is a reply to message #289385]

Fri, 21 December 2007 03:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

rony
Messages: 3
Registered: December 2007

Junior Member

All the prepared statement, conn, and result set are closed...
No problem there

Report message to a moderator

Re: Maximum cursor overloaded problem [message #289393 is a reply to message #289392]

Fri, 21 December 2007 03:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Maximum cursor overloaded problem [message #289395 is a reply to message #289393]

Fri, 21 December 2007 03:57

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

Report message to a moderator

Previous Topic:	Executing a Stored Procedure with visual basic 6
Next Topic:	Connection breaks after Alter System flush Shared Pool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 10:20:17 CST 2024