Re: max open cursors

Hi

[Quoted] [Quoted]     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>...
>Hi there !
>I have problem a in forms 4.5. I created one big procedure wich has around
>40 "for loop end loop" style cursors some "select into" statements and few
>dynamic sql statements.
>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.
>
>what is wrong with that ? How can I check the number of open cursor during
>the run time ?
>
>thanx in advance !
>
>
>
>
Received on Mon May 03 1999 - 07:26:43 CEST