Re: Help Debugging CURSORS (context areas)

> ... we inevitably get one of the following errors:
> (most common) ORA-00604: error occurred at recursive SQL level 1
> (this often occurs during an INSERT that is performed by forms)
> (also common) ORA-01000: maximum open cursors exceeded
> FRM-40735: trigger raised unhandled exception INVALID_CURSOR
>
> Since max_cursors is set to 50 in init.ora, ...

This is a persistent problem in all versions of SQL*Forms. Many cursors are opened for data dictionary access "behind your back", so you cannot blame yourself for all of the open cursors.

My solution was to set max_cursors = 255 in the INIT.ORA. This creates some additional memory usage within each user process, but not enough to cause concern.

--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm_at_dlogics.com                                 Motto: Just show me the code