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

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 18 Dec 2008 05:04:31 -0800 (PST)
Message-ID: <03500a7a-53c1-4f65-9964-51c97ada7125@s9g2000prm.googlegroups.com>


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
Received on Thu Dec 18 2008 - 07:04:31 CST

Original text of this message