-
Expert Member
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.
-
Expert Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules