Joined: 03 Feb 2007 Posts: 175 Location: PUNE(INDIA)
I have a batch program that uses a cursor. It fetches row depending upon a condition and updates the same with option CURRENT OF cursor.
Now my question is do I need to handle SQLCODE = 100 while updation ?
Is there any possibility that the row fetched by cursor is deleted by another user before it is updated?
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
For your second question.
When you open any Table, it won't allow any other user to do anything to that table, until your program end
I dont agree with the above sentence. It cant be said like that without considering the isolation levels. I would say it would depend on the isolation level. Its an interesting concept please go thru it. Thanks