Next badge 0/1
~944 people reached
- 0 posts edited
- 0 helpful flags
- 0 votes cast
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...
|asked||enq: TX - row lock contention creating session waits|