SEO

#1 (**permalink**) 02-24-2008, 08:41 AM

If I come out of the SQL prompt after performing some DML statements
and without doing commit, I find that the automatic commit has been
done for those statements. I would like to know what exactly is the
flag that controls this. I want to set that flag accordingly such
that, the transactions are not automatically committed whenever the
user comes out of the SQL prompt.

Thanks!

#2 (**permalink**) 02-24-2008, 08:41 AM

qazmlp wrote:
> If I come out of the SQL prompt after performing some DML statements
> and without doing commit, I find that the automatic commit has been
> done for those statements. I would like to know what exactly is the
> flag that controls this. I want to set that flag accordingly such
> that, the transactions are not automatically committed whenever the
> user comes out of the SQL prompt.
>
Hello qazmlp,

Oracle always commits before and after a DML operation. I don't think
there is some flag to disable that.

Hope that helps,
Lothar

--
Lothar Armbrüster | la@oktagramm.de
Hauptstr. 26 | la@heptagramm.de
D-65346 Eltville | lothar.armbruester@t-online.de

#3 (**permalink**) 02-24-2008, 08:41 AM

"qazmlp" <qazmlp1209@rediffmail.com> a écrit dans le message de
news:db9bbf31.0411030852.998d69b@posting.google.co m...
> If I come out of the SQL prompt after performing some DML statements
> and without doing commit, I find that the automatic commit has been
> done for those statements. I would like to know what exactly is the
> flag that controls this. I want to set that flag accordingly such
> that, the transactions are not automatically committed whenever the
> user comes out of the SQL prompt.
>
> Thanks!

Have a look at "set autocommit" statement:
http://download-west.oracle.com/docs...13.htm#1012156

--
Regards
Michel Cadot

#4 (**permalink**) 02-24-2008, 08:41 AM

"Lothar Armbruester" <lothar.armbruester@t-online.de> a écrit dans le message de
news:PM0003E7FE586F3A32@hades.none.local...
> qazmlp wrote:
> > If I come out of the SQL prompt after performing some DML statements
> > and without doing commit, I find that the automatic commit has been
> > done for those statements. I would like to know what exactly is the
> > flag that controls this. I want to set that flag accordingly such
> > that, the transactions are not automatically committed whenever the
> > user comes out of the SQL prompt.
> >
> Hello qazmlp,
>
> Oracle always commits before and after a DML operation. I don't think
> there is some flag to disable that.

During a DDL statement not a DML statement and only one that changes the dictionary.

--
Regards
Michel Cadot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Flag controlling the 'automatic commit' mode??