ORA-00604, ORA-01000

From: Andreas Ursprunger <andreas.ursprunger_at_telekom.at>
Date: 2000/04/18
Message-ID: <38fc171c$0$80800@SSP1NO17.highway.telekom.at>#1/1

Hello !

I have a connection via JDBC to ORACLE 8.0.4 and sometimes I get the following error-message:

"ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded"

What can I do ?

Should I close my ResultSets immediately after use ? (BTW: I expected my ConnectionBroker to do this.)
Should I increase the number of connections to the database ? (I'm not really sure if this can solve the Problem.)

Do you have a better idea ?

Please, if anybody of you has a solution for that, please let me know. :-) Thanks a lot, Andreas Received on Tue Apr 18 2000 - 00:00:00 CDT