Oracle: "for update clause" and then using using "update?

Question

What are the advantage and disadvantages of using a select for update in a cursor Using the "for update clause" and then using useing "update... for current cursor" is a good way to make sure that no one else is changing the rows you are working with.

Answer 1

If you use this then you cannot issue a commit within the loop. A commit will release all locks and invalidate your cursor.