Re: ORA-01000: maximum open cursors exceeded PROBLEM

From: <saropani_at_my-dejanews.com>
Date: Sat, 20 Jun 1998 12:21:20 GMT
Message-ID: <6mg9g0$mtj$1@nnrp1.dejanews.com>

In article <6mam3n$1qkm$1_at_urano.inet.it>, "Paolo Quaglia" <paolo_at_sitek.it> wrote:
>
> Hi ,
> I'm developing an Intranet Application :
> I have developed several input Forms and I Use Servlet-Jdbc_odbc connection
> to Oracle.
> The problem is:
> After some time I use the forms I have this Error:
> - ORA-01000: maximum open cursors exceeded
> NB: I use a permanent connection in the servlet and when i have the error I
> restart the connection. ( so the connection will restarted many times!!)
>
> I have read that I can increment the value of a variable: but I don't know
> the where I must
> update this value..
>
> HELP!!
>
>

Hi Paolo,

It is very simple. Just edit $ORACLE_HOME/initSID.ora file and increase the value of OPEN_CURSOR parameter. That's it.

Regards,
Saravanan

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Jun 20 1998 - 07:21:20 CDT