Reputation
Top tag
Next privilege 15 Rep.
Flag posts
Badges
2
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Jul
13
awarded  Popular Question
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