I am using Oracle 9i with C# windows application and .net Framework 2.0
My problem is I have a table MONTHLYBILL WITH COLUMN VALUE AND MEMBER_ID
I have multiple users updating VALUE WHERE MEMBER_ID=1
For this my C# code is UPDATE MONTHLYBILL SET VALUE = VALUE+[VARIABLE] WHERE MEMBER_ID=100.
Now say user1 updates with VALUE=100. At same time user2 is updating value with 200. over all DB will get 300.
I cant use readcommitted because both users may commit at same time so I am using ISOLATION LEVEL SERIALIZABLE
Now what happens in say user 1 has enterd update loop but yet to commit. same time user2 enters update loop i get an error ORA-08177