February 5th, 2004, 02:10 AM
too many Cursor Error
There are many procedures written in Developer 2000. these contain insert and Update Statements in a Cursor that Follows "FOR" Loop statement.
The Problem is Then "Too Many Open Cursor" error comes into picture.
We try to manually close the cursor But it throws out an exception saying that no such cursor exist But when I go and Check the Open Cursor Log through the statement Select * FROM V$OPEN_CURSOR, The Insert and Updates Statement of that procedure is shown as Open... Why is it so... Is it something specific as relates to Developer Forms???