Re: max open cursors
Date: Mon, 3 May 1999 16:21:36 +0200
Message-ID: <7gkat5$or0$1_at_talia.mad.ttd.net>
The best thing you can do is to use explicit cursors.
mgyuri escribió en mensaje <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 - 16:21:36 CEST