Re: max open cursors
Date: Mon, 3 May 1999 08:52:10 +0200
Message-ID: <7gjgv2$bm0_at_helka.iif.hu>
[Quoted] Ok, I can do that, but how could that cursors remain opened ?
M.
Pradhan wrote in message ...
> Increase the open_cursors parameter value. Also according to oracle
>"Be generous with the OPEN_CURSORS parameter, especially in an Oracle
>Forms application environment. This will be show stopper for your
>application
>if it is set too low in initialization parameter file."
>
>HTH
>Pradhan
>mgyuri wrote in message <7gidpv$iuu_at_helka.iif.hu>...
>>when i run this program i have "ORA-01000 maximum open cursors exceeded "
>>(it is 100, defined in initoracl.ora), and I do not understand how could
it
>>happend, because as I know the "for loop end loop" cursor handling closes
>>the cursors automatically, so I can not miss the closing.
Received on Mon May 03 1999 - 08:52:10 CEST