Re: Sql*plus Auto-Commit

"William Robertson"
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#i2698639
> tells us:
> "SET AUTOCOMMIT does not alter the commit behavior when SQL*Plus exits.
> Any uncommitted data is committed by default."
>
> Possibly the OP read that and wondered how to change this "default"
> behaviour, which you cannot, since there is an implicit COMMIT when
> exiting from SQL*Plus (for example, try violating a deferred constraint
> then exiting. Just for fun, set a WHENEVER SQLERROR EXIT ROLLBACK
> condition first.)
>
> I suppose the page for EXIT
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12023.htm
> does say
> "Commit on exit ... is performed regardless of the status of SET
> AUTOCOMMIT."
>
> However you might still wonder whether some alternative exists that
> does not involve the autocommit setting (there isn't one). Sometimes
> this type of thing is not obvious from the documentation, though.

Exactly
I RTFM that part

Hence I posted question asking you gurus & hoping there just might be a way of avoiding "ooops I exited "by accident" and my sh*t got all COMMITTED !!!" Received on Mon Oct 30 2006 - 09:39:59 CST