Re: ORA-01000: maximum open cursors exceeded PROBLEM

Oracle is saying that too many requests (select, update, delete)  are open for this database. You might talk to the DBA. --  there's an initialiation parameter covering open cursors  but this may already be too large for comfort. So look  at your code, and close what you've opened when you're through. Also, it may be that one request  generates more than one open cursor. There are trace techniques that may help figure it out:  fellow programmers or the DBA may be able to help you.

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!!
>
>

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