Re: Sql*plus Auto-Commit

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 27 Oct 2006 11:40:03 -0700
Message-ID: <1161974402.960860.41970@i3g2000cwc.googlegroups.com>

On Oct 27, 2:18 pm, "klabu" <nosuchuser_at_gmail_dot_com> wrote:
> I exited SQL*plus with commit/rollback and my transaction was coimmitted.
>
> How can I disable this auto-commit behavior ?
>
> thanks
>
> --
> 10gR2

>From the 10gR2 SQL*Plus Users Guide >> EXIT with no clauses commits and
exits with a value of SUCCESS. <<

Try EXIT ROLLBACK. As long as autocommit is off that should work.

HTH -- Mark D Powell -- Received on Fri Oct 27 2006 - 13:40:03 CDT