11 reputation
1
bio website
location
age
visits member for 2 years, 4 months
seen Aug 10 '12 at 13:40

Aug
17
awarded  Student
Jul
7
comment enq: TX - row lock contention creating session waits
All these Update statements are inside a For loop. If I put a COMMIT inside the loop it will commit each and every thing. Is it acceptable committing each and everything one by one, what if there occurs an error in between. Dont we generally put a Commit as the last statement inside a procedure and ROLLBACK inside exception block. If I put a commit inside that for loop, putting Rollback in exception block becomes redundant. Isn't it? I hope you got my doubt...
Jun
18
asked enq: TX - row lock contention creating session waits