network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 11 months |
| seen | Aug 10 '12 at 13:40 | |
| stats | profile views | 1 |
|
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 |
