-
Cursors Processing
When I was inside a cursor loop I am updating records but not commiting records.
Cursor ....
LOOP
Updating each record balance amount
End Loop
Commit;
Some times I need to process each record balance two or three times. Does it cosider the balance amount before entering cursor loop or updated balance amount?
-
Re: Cursors Processing
As you are commiting outside the loop it will consider the old value only.
-
Re: Cursors Processing
Cusor takes values from the result set. Does a Cursor not Update the values in the result set? Which area does it use to store updated value? If it use the result set it should return updated values only.