Re: ORA-01000 maximum open cursors exceeded
Date: 1998/01/28
Message-ID: <886004588.1288175623_at_dejanews.com>#1/1
In article <6allus$a75$1_at_us1.rhbnc.ac.uk>,
dipen_at_dcs.rhbnc.ac.uk ( 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.
For a Windows95 or Windows NT PC, set OPEN_CURSORS to 200 in file C:\ORAWIN95\DATABASE\INITORCL.ORA The "ORA-01000 Maximum open cursors exceeded" and ORA-00604 messages should go away.
I'm not much at explaining cursors, since I don't fully understand things myself. But I'll try... The database uses a "cursor" for every select statement your application sends it. It keeps these around for later use just in case you issue the same select again. If it still has a copy of the cursor (select command) from the first time it was used, it saves time and overhead to reuse the old copy.
The reason why the database and forms leaves the cursors "open" is a mystery to me. I think it is pretty closely related to the number of LOV's you use--at least that is where I have hit the limit in the past.
Be sure all your selects within forms that you write within pl/sql are from explicit cursors that you open, fetch and then close.
Regards,
Steve Cosner
http://members.aol.com/stevec5088
Downloadable Quick Access utility form: Display and update any table.
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Jan 28 1998 - 00:00:00 CET