Re: Turning off DML commit when session is exited or disconnected
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 18 Dec 2008 07:11:46 -0800
Message-ID: <1229613105.99436@bubbleator.drizzle.com>
>
> in sqlplus:
>
> SQL> set autocommit off
>
> ?
Date: Thu, 18 Dec 2008 07:11:46 -0800
Message-ID: <1229613105.99436@bubbleator.drizzle.com>
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.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Dec 18 2008 - 09:11:46 CST