Re: maximum open cursors exceeded

Article View: borland.public.jbuilder.java.language

Article #15721

Back to borland.public.jbuilder.java.language Previous Next

#15721

From: Richard Spuller
Date: Mon, 03 May 1999 00:00

17 lines
959 bytes

Hey,

  You must set the "OPEN_CURSORS" in the init-file of the Oracle database and
restart the DB.

  e.g: OPEN_CURSORS=2000  (i think 2000 is enough)




Celil Germeyan wrote:

> I get the " ORA-01000: maximum open cursors exceeded" SQLException error. My
> program executes queries. I think I am not closing either my STATEMENTS or
> my RESULTSETS...
>
> Your help is greatly appreciated.

Technical Details

Message-ID: <372DD28A.308BC9EA@itd.at>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7ga1a3$o7a37@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,4438f6cf8ce327cf
X-Google-Attributes: gidf74b3,public
From: Richard Spuller <rs@itd.at>
Subject: Re: maximum open cursors exceeded
Date: 1999/05/03
Message-ID: <372DD28A.308BC9EA@itd.at>
X-Deja-AN: 473560890
Content-Transfer-Encoding: 7bit
References: <7ga1a3$o7a37@forums.borland.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.jbuilder.java.language

Reply to Parent Message