Re: ORA-01000: maximum open cursors exceeded

From: Raffaella Coccioli <r.coccioli_at_libero.it>
Date: Fri, 18 Aug 2000 08:45:12 +0200
Message-ID: <8nim6k$3fn6$1@stargate1.inet.it>

"Walter T Rejuney" <BlueSax_at_Unforgetable.com> ha scritto nel messaggio news:39995918.C807FCAA_at_Unforgetable.com...
> Stefan Merath wrote:
> >
> > Hello,
> >
> > my Servlet-Application tries to connect to Oracle 8i via JDBC. Sometimes
> > (esp. in complex queries) the queries result in the following error:
> >
> > java.sql.SQLException: ORA-01000: maximum open cursors exceeded
> >
> > Is there a possibility to increase the max number of open cursors?
>
> Yes. Change it in initxxx.ora

Hi,
It's not necessary to increase the number of maximum open curson: all the times that you make a Statement you have to close it, after reading the Resultset.
Raffa Received on Fri Aug 18 2000 - 01:45:12 CDT