SQLPlus seems to autocommit my transaction

From: Will <w_keeling_at_yahoo.com>
Date: 28 Mar 2003 08:35:05 -0800
Message-ID: <cd46a84c.0303280835.218a5ba8@posting.google.com>

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)? Received on Fri Mar 28 2003 - 10:35:05 CST