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

In article <1229613105.99436_at_bubbleator.drizzle.com>, damorgan_at_psoug.org says...>
> Jeremy wrote:
> > In article <619d22a2-cb7a-4d1d-a889-11e4a9014d58
> > @r36g2000prf.googlegroups.com>, rcllnx_at_gmail.com says...>
> >> 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
> >
> > in sqlplus:
> >
> > SQL> set autocommit off
> >
> > ?
>
> It is best to test advice before giving it. <g>
>
> In sqlplus, not sqlplusw, autocommit is off by default.
> Closing the executable commits uncommited transactions.
> You have misunderstood the autocommit parameter.

It appears so.

<goes to make a coffee>

-- 
jeremy