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

From: DA Morgan <>
Date: Thu, 18 Dec 2008 07:11:46 -0800
Message-ID: <>

Jeremy wrote:
> In article <619d22a2-cb7a-4d1d-a889-11e4a9014d58
>>, 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Dec 18 2008 - 09:11:46 CST

Original text of this message