Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trivia Question: Any point to CommitTrans with no Rollback?

Trivia Question: Any point to CommitTrans with no Rollback?

From: Larry Leonard <Spam_at_DefinitiveSolutions.com>
Date: 2 May 2003 10:43:17 -0700
Message-ID: <27270a53.0305020943.58de797b@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US