Re: Turning off DML commit when session is exited or disconnected

On 18 dec, 15:12, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> On 18 Dic, 14:04, sybrandb <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > On 18 dec, 12:28, oracle user <rcl..._at_gmail.com> wrote:
>
> > > If i issue a DML statment in oracle database from sqlplus session
> > > (where autocommit is off by default ) and then 'exit' or 'disc' the
> > > session without explicitly commiting the DML ,the DML gets commited .
> > > Is it possible to turn off this default behaviour.
> > > Thanks in Advance
>
> > It is NOT possible.
> > How would it be? By design, your transaction ends by exiting Oracle.
> > It is a feature of the database, not of sql*plus.
> > If you don't want to commit your transaction, you issue rollback.
> > This won't get you RSI.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Well, i've to admit that this for me is a surprise. I've always used
> explicit commit or rollback
> but i've never knew that exiting or disconnecting from sqlplus
> transaction gets automatically
> committed.  It is true that this behaviour cannot be changed, but it
> is a feature
> of SQL*Plus (http://download.oracle.com/docs/cd/B19306_01/server.102/
> b14357/ch12023.htm#i2697968)
> If you kill a session, oracle rollbacks any changes.
>
> Regards,
>  Cristian- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Cristian,
It is NOT a feature of sql*plus. It is a feature of Oracle. It applies to anything connecting to Oracle, leaving with a proper exit command.

--
Sybrand Bakker
Senior Oracle DBA