max open cursors
From: mgyuri <mgyuri_at_freemail.c3.hu>
Date: Sun, 2 May 1999 22:49:01 +0200
Message-ID: <7gidpv$iuu_at_helka.iif.hu>
Hi there !
[Quoted] [Quoted] I have problem a in forms 4.5. I created one big procedure wich has around [Quoted] 40 "for loop end loop" style cursors some "select into" statements and few dynamic sql statements.
[Quoted] 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 [Quoted] happend, because as I know the "for loop end loop" cursor handling closes the cursors automatically, so I can not miss the closing.
Date: Sun, 2 May 1999 22:49:01 +0200
Message-ID: <7gidpv$iuu_at_helka.iif.hu>
Hi there !
[Quoted] [Quoted] I have problem a in forms 4.5. I created one big procedure wich has around [Quoted] 40 "for loop end loop" style cursors some "select into" statements and few dynamic sql statements.
[Quoted] 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 [Quoted] 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 Sun May 02 1999 - 22:49:01 CEST