Re: SQLPlus seems to autocommit my transaction

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 28 Mar 2003 19:06:19 +0100
Message-ID: <ln398vkhbgt31asgup4gsqilm9r97g1tq1@4ax.com>

On 28 Mar 2003 08:35:05 -0800, w_keeling_at_yahoo.com (Will) wrote:

>I have auto commit off in SQLPlus
>
>When I insert into a table and then quit SQLPlus without issuing a
>'commit', SQLPlus seems to automatically commit the change. When I go
>back into SQLPlus I see the change has been made.
>
>However, if I insert into the table, check I can see the inserted row
>and then issue a 'rollback' immediately after, the change is rolled
>back as I expect.
>
>Is SQLPlus supposed to commit on exit even with autocommit switched
>off (I'm using Oracle 9.2.0.1.0)?

Exactly, and moreover it is documented in the sql*plus manual, and it has been working that way for more than 15 years.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 28 2003 - 12:06:19 CST