Re: SQLPlus seems to autocommit my transaction

From: Alison Holloway <Xalison.holloway_at_oracle.comX>
Date: Mon, 31 Mar 2003 13:36:12 +1000
Message-ID: <3E87B7AC.6030406@oracle.comX>

EXIT ROLLBACK will do what you want. EXIT COMMIT is actually what happens when you use EXIT alone. "EXIT with no clauses commits and exits with a value of SUCCESS."

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1009789

Alison

Tim X wrote:
> Sybrand Bakker <gooiditweg_at_nospam.demon.nl> writes:
>
>

>>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.
>>

>
>
> Huh? Are you sure? What is the point of auto commit if sqlplus commits
> on exit anyway? I thought if auto commit was turned off, nothing would
> cause a commit except an explicit commit statement. Certainly going to
> do a lookup of my SQLPlus documentation when I get back to work on
> Monday.
>
Received on Sun Mar 30 2003 - 21:36:12 CST