ORA-00604, ORA-01000

From: Andreas Ursprunger <andreas.ursprunger_at_telekom.at>
Date: Tue, 18 Apr 2000 10:04:40 +0200
Message-ID: <38fc171c$0$80800_at_SSP1NO17.highway.telekom.at>

Hello !

[Quoted] 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 [Quoted] 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 - 10:04:40 CEST

This message: [ Message body ]
Next message: richard.a.slochowsky_at_us.arthurandersen.com: "Extended Absence Response: Deja.Com Daily Digest: comp.databases .oracle.tools 2/2"
Previous message: Sybrand Bakker: "Re: Probs with Downloading Ora8i - personal..."
Next in thread: Sybrand Bakker: "Re: ORA-00604, ORA-01000"
Reply: Sybrand Bakker: "Re: ORA-00604, ORA-01000"
Reply: Cyril Van Agt: "Re: ORA-00604, ORA-01000"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message