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

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_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de