ORA-01000 maximum open cursors exceeded
From: D. Shah <dipen_at_dcs.rhbnc.ac.uk>
Date: 1998/01/27
Message-ID: <6allus$a75$1_at_us1.rhbnc.ac.uk>#1/1
Date: 1998/01/27
Message-ID: <6allus$a75$1_at_us1.rhbnc.ac.uk>#1/1
[Quoted] [Quoted] Does anyone know how I can resolve this error?
[Quoted] 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 Tue Jan 27 1998 - 00:00:00 CET