Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Trivia Question: Any point to CommitTrans with no Rollback?
I'm not an Oracle newbie, but I'm far from a guru.
I've inherited a lot of OO4O code that uses what to me looks like an odd idiom. In many places - most of the time, in fact - a BeginTrans is called, some work is done, and then a CommitTrans is done. There's no error checking, and there's no call to Rollback anywhere.
Am I correct in thinking that a transaction without the possibility of a Rollback is pointless? Or is there some advantage (performance?) to wrapping several actions in a transaction, even if you can never rollback? OO4O methods don't throw exceptions (well, some of them do, but not the ones I use), so I don't think that's it.
Ideas? TIA. Received on Fri May 02 2003 - 12:43:17 CDT
![]() |
![]() |