Re: ORA-01000: maximum open cursors exceeded PROBLEM

Paolo Quaglia wrote:
>
> Hi ,
> I'm developing an Intranet Application :
> - ORA-01000: maximum open cursors exceeded

You must update the value in your initorcl.ora file (C:\ORANT\DATABASE\) if you are under NT.

Just add the line :
open_cursors = x
where x is the integer value of your maximum cursors simultaneously opend (I put 100, it works great).

Zahi

--
Zahi Al-Jamous e-mail: aljamous_at_crv.pechiney.fr Groupe GIL
Pechiney-CRV

BP 27				tel (work): +33.(0)4.76.57.82.45
F-38340 Voreppe			tel (cell): +33.(0)6.14.55.16.88