Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-00604, ORA-01000

Re: ORA-00604, ORA-01000

From: Cyril Van Agt <cvanagt_at_netapp.com>
Date: 2000/04/21
Message-ID: <3900694E.437F12C1@netapp.com>#1/1

There is a parameter (maxopencusrsors) to increase in the iniXXX.ora file.

Cyril

Andreas Ursprunger a écrit :

> 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 Fri Apr 21 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US