Re: AutoCommit - How does it works?

From: <fitzjarrell_at_cox.net>
Date: Mon, 02 Jul 2007 11:57:56 -0700
Message-ID: <1183402676.626106.231690@m36g2000hse.googlegroups.com>

On Jul 2, 11:38 am, Mariano <mariano.calan..._at_gmail.com> wrote:
> My question is quite simple, how autocommit influenced the developing
> of a procedure, trigger or java application that run on Oracle server
> with autocommit ON???
> In other words: if I use autocommit, can avoid to write explicitely
> the begin and the end of the transaction?

Define how you'd write the beginning of a transaction in Oracle. With or without autocommit enabled I still understand such activity to begin with CREATE, INSERT, UPDATE or DELETE. And why you'd choose to use autocommit is a mystery to me, unless you're exceptionally lazy. Should any part of a multiple-step transaction fail you're, well, screwed, as autocommit would set in stone, so to speak, parts of your transaction rendering your data inconsistent.

I agree with Michel: never user autocommit.

David Fitzjarrell Received on Mon Jul 02 2007 - 13:57:56 CDT