Re: Flag controlling the 'automatic commit' mode??

"Lothar Armbruester" <lothar.armbruester_at_t-online.de> a écrit dans le message de news:PM0003E7FE586F3A32_at_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