Re: ORA-01000 maximum open cursors exceeded

D. Shah wrote:
>
> Does anyone know how I can resolve this error?
>
> It occurs when I open multiple forms.
>
> I have tried putting the following command after commit statements:
>
> set_form_property('pay_bud',CURSOR_MODE,close_at_commit);
>
> to try to free up the number of cursors open - but to no avail.
>
> ORACLE has suggested shutting down ORACLE and increasing the value of
> OPEN_CURSORS before restarting ORACLE. Unfortunately, I haven't a
> clue where I do this!
>
> Any help would be much appreciated!
>
> Best Regards
> Dipen
>
> Ps Can someone provide an explanation of what a cursor is? I have
> tried searching for a description - but have had no success.

There are 2 files that contain the database initialization values. Their names are based on your SID. If your SID is DEV, then the files would be named initDEV.ora and configDEV.ora. I think that the init file contains the open_cursors spec.

I think of cursors as a temporary holding place for information. I typically define a cursor as a query that I need. When the cursor is opened, it holds all the records that match my select statement. I can then fetch each record one at a time and do my work on them.

Good Luck,
Steve Received on Tue Jan 27 1998 - 00:00:00 CET