Re: :ORA-01000 (too many open cursors)

Check the value of OPEN_CURSORS in your init.ora file. the value of this parameter could be too low. Increase this value ( around 200 should be adequate) and restart your database. This should solve your problem

imtiaz_at_qatar.net.qa

Eric Hartzenberg <eric_at_erichome.demon.co.uk> wrote in article <S2mwsCAIEWQzEwUm_at_erichome.demon.co.uk>...
> In article <333A9619.298F_at_ryback.com>, Ken Johnson <kjohnson_at_ryback.com>
> writes
> >Discart Miguel wrote:
> >>
> >> This message is crossposted to :
> >>

comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.serve r,
> >comp.databases.oracle.tools
> >>
> >> Hi to all of you,
> >>
> >> I need your help, so here is my problem. On a form application
> >> (v4.5), I have a lot of fonction which call cursor to populate
> >> fields.
> >>
> >> I use these cursors always in a :
> >> FOR c1 IN CURSOR_NAME LOOP
> >> my_job
> >> END LOOP;
> >>
> >> The problem is sometimes I got an error ora-01000 (which mean to many
> >> cursor open at one time) but that never happen twice the same way. Is
> >> the meaning of this error that I don't understand or the use of the
> >> DO..LOOP.
> >>
> >> Anyone got a clue?
> >>
> >> TIA
> >>
> >> --
> >>
> >> ----------------------------------------------------------------
> >> Regards,
> >> Miguel Discart
> Single forms with lots of functionality (many blocks,lookups etc) can
> eat up your allocation of cursors pretty quickly. Particularly if the
> user keeps the form open all day (order-entry form , for example). Maybe
> you could put infrequently used features in subordinate forms. Closing
> these sub-forms releases the cursors associated with blocks.
> ________________________________________________________________
> | ~~~~~~~~~~~~~~~~~~~~ | ERIC HARTZENBERG | ~~~~~~~~~~~~~~~~~~~ |
> | Email : eric_at_erichome.demon.co.uk Compuserve : 100073,21 |
> | Homepage : www.erichome.demon.co.uk |
> |________________________________________________________________|
>
  Received on Fri Apr 04 1997 - 00:00:00 CEST