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

From: Jochen Kutscheruk <>
Date: Thu, 12 Aug 1999 16:11:21 +0200
Message-ID: <>

Hi Danny,
just put the line
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.

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