Re: Turning off DML commit when session is exited or disconnected
Date: Thu, 18 Dec 2008 15:14:20 -0000
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>
-- jeremyReceived on Thu Dec 18 2008 - 09:14:20 CST