Re: ORA-01000 maximum open cursors exceeded
Date: 1998/01/28
Message-ID: <6ana5s$qef_at_bgtnsc03.worldnet.att.net>#1/1
You need to configure in initSID.ora file like following.
(Be sure to check the allowable limit, I think it's 255)
open_cursors=255
Once u do this shutdown the database and startup again
Good luck
Madhu Cherukuri
D. Shah wrote in message <6allus$a75$1_at_us1.rhbnc.ac.uk>...
>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 Wed Jan 28 1998 - 00:00:00 CET