Re: SQLPlus seems to autocommit my transaction

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 30 Mar 2003 21:04:15 +0100
Message-ID: <3e87da03_1@mk-nntp-1.news.uk.worldonline.com>

"Tim X" <timx_at_spamto.devnul.com> wrote in message news:87fzp5rpy5.fsf_at_tiger.rapttech.com.au
>
> 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.
>

This has *nothing* to do with autocommit. Autocommit attempts to commit each statement once it has executed successfully (daft idea).

If you exit SQL*Plus cleanly, and leave your last uncommitted transaction open, it will commit it for you. This how SQL*Plus has behaved for the last 15 years, as Sybrand said.

Everything depends on client behaviour. SQL*Plus is just another client. In any case, no-one should rely on the default behaviour of a particular client. Commits or rollbacks should be issued explicitly as necessary.

Regards,
Paul Received on Sun Mar 30 2003 - 14:04:15 CST