Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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