Home » Open Source » Programming Interfaces » Maximum cursor overloaded problem
Maximum cursor overloaded problem [message #289385] Fri, 21 December 2007 03:03 Go to previous 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..
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Executing a Stored Procedure with visual basic 6
Next Topic: Connection breaks after Alter System flush Shared Pool
Goto Forum:
  


Current Time: Fri Mar 29 03:59:10 CDT 2024