Re: How to avoid ORA-01000 maximum open cursors exceeded in Forms 5.0

From: Jochen Kutscheruk <jochen.kutscheruk_at_merlin-zwo.de>
Date: Thu, 12 Aug 1999 16:11:21 +0200
Message-ID: <37B2D609.6160532_at_merlin-zwo.de>


Hi Danny,
just put the line
  open_cursors=1000
into your init.ora-File and restart the database. Everything should work fine then. And this parameter doesn't harm your database in any way.
Jochen

Danny Lee schrieb:

> Hi, ORACLE experts:
>
> I used many (2-level) cursor-for-loops (in serial manner, not simultaneously) to process data.
> It seems to me that Forms 30 keeps all the cursors in the 'open' state even though it should be closed
> after the loop is exited.
> The DBA told me that I should be about to open 50 cursors, but I still get the
>
> ORA-01000 maximum open cursors exceeded
>
> error.
>
> Is this typical for Forms?
>
> How to get around it?
>
> Thanks in advance for your expertise and help.
>
> Danny
Received on Thu Aug 12 1999 - 16:11:21 CEST

Original text of this message