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

Danny Lee wrote:
>
> 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

Forms does not close cursors to speed up their re-use...

In a heavy forms environment, crank up the open cursors in your database init.ora..

Cheers
Connor

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."