I exited SQL*plus with commit/rollback and my transaction was coimmitted.

How can I disable this auto-commit behavior ?

thanks

--
10gR2

klabu wrote:
> I exited SQL*plus with commit/rollback and my transaction was coimmitted.
>
> How can I disable this auto-commit behavior ?
>
> thanks
>
> --
> 10gR2

Don't know if google lost my previous reply, but you can't. However,
you can exit rollback. See the manual.

jg
--
@home.com is bogus.
http://www.mcphee.com/categories/weird.html

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

klabu wrote:
> I exited SQL*plus with commit/rollback and my transaction was coimmitted.
>
> How can I disable this auto-commit behavior ?
>
> thanks
>
> --
> 10gR2

Has reading the manual occurred to you?

http://tahiti.oracle.com



David Fitzjarrell

Create a login.sql file if you do not already have one and add the line

set autocommit off

I suggest you read the SQL*PLUS Users Guide for further details re. the
location of the file.

Jerry

klabu wrote:
> I exited SQL*plus with commit/rollback and my transaction was coimmitted.
>
> How can I disable this auto-commit behavior ?
>
> thanks
>
> --
> 10gR2

On Fri, 27 Oct 2006 14:18:06 -0400, klabu wrote:

> How can I disable this auto-commit behavior ?

SET RTFM ON

--
http://www.mladen-gogala.com

Mladen Gogala wrote:
> On Fri, 27 Oct 2006 14:18:06 -0400, klabu wrote:
>
> > How can I disable this auto-commit behavior ?
>
> SET RTFM ON
>
> --
> http://www.mladen-gogala.com

LOL

not bad, for once.

-- Mark --

> klabu wrote:
> > I exited SQL*plus with commit/rollback and my transaction was coimmitted.
> >
> > How can I disable this auto-commit behavior ?
> >
> > thanks
> >
> > --
> > 10gR2

jerry wrote:
> Create a login.sql file if you do not already have one and add the line
>
> set autocommit off
>
> I suggest you read the SQL*PLUS Users Guide for further details re. the
> location of the file.
>
> Jerry

I'm not sure how that helps here.

http://download-uk.oracle.com/docs/c...0.htm#i2698639
tells us:
"SET AUTOCOMMIT does not alter the commit behavior when SQL*Plus exits.
Any uncommitted data is committed by default."

Possibly the OP read that and wondered how to change this "default"
behaviour, which you cannot, since there is an implicit COMMIT when
exiting from SQL*Plus (for example, try violating a deferred constraint
then exiting. Just for fun, set a WHENEVER SQLERROR EXIT ROLLBACK
condition first.)

I suppose the page for EXIT
http://download-uk.oracle.com/docs/c...57/ch12023.htm
does say
"Commit on exit ... is performed regardless of the status of SET
AUTOCOMMIT."

However you might still wonder whether some alternative exists that
does not involve the autocommit setting (there isn't one). Sometimes
this type of thing is not obvious from the documentation, though.

"Mladen Gogala"
> SET RTFM ON
>


klabu@ppd1> SET RTFM ON
SP2-0158: unknown SET option "RTFM"

maybe you should RTFM

"William Robertson"
> http://download-uk.oracle.com/docs/c...0.htm#i2698639
> tells us:
> "SET AUTOCOMMIT does not alter the commit behavior when SQL*Plus exits.
> Any uncommitted data is committed by default."
>
> Possibly the OP read that and wondered how to change this "default"
> behaviour, which you cannot, since there is an implicit COMMIT when
> exiting from SQL*Plus (for example, try violating a deferred constraint
> then exiting. Just for fun, set a WHENEVER SQLERROR EXIT ROLLBACK
> condition first.)
>
> I suppose the page for EXIT
> http://download-uk.oracle.com/docs/c...57/ch12023.htm
> does say
> "Commit on exit ... is performed regardless of the status of SET
> AUTOCOMMIT."
>
> However you might still wonder whether some alternative exists that
> does not involve the autocommit setting (there isn't one). Sometimes
> this type of thing is not obvious from the documentation, though.


Exactly
I RTFM that part

Hence I posted question asking you gurus & hoping there just might be a way
of avoiding "ooops I exited "by accident" and my sh*t got all COMMITTED !!!"