February 5th, 2004, 01:10 AM
|
|
Contributing User
|
|
Join Date: Nov 2003
Posts: 99
Time spent in forums: 3 h 12 m 17 sec
Reputation Power: 5
|
|
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???
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
