Re: ORA-01000 maximum open cursors exceeded

Its in the Init.ora file.

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.
Received on Mon Feb 02 1998 - 00:00:00 CET