Oracle, like DB/2 can' t set it to on. The autocommit ***on***  in ORA ODBC is a trick.
It simply silently adds commit once in a while (after every statement).
But please to make the vokabulary easy don't refer to begin, but to 'begin work'
in this context. 'begin' will mean begin a statement block, not a transaction block.

Andreas

> How do you set autocommit off in ORACLE embedded SQL? I only know this
> from ODBC.



Thu, 19 Mar 1998 16:42:15 +-100
Zeugswetter Andreas <andreas.zeugswetter@telecom.at>
AW: [HACKERS] Begin statement again
Zeugswetter Andreas writes:
> Oracle, like DB/2 can' t set it to on. The autocommit ***on***  in ORA ODBC is a trick.
> It simply silently adds commit once in a while (after every statement).

I know. The problem we were talking about was the automatic beginning of a
transaction. No need to say "begin work" it just starts.

> But please to make the vokabulary easy don't refer to begin, but to 'begin work'
> in this context. 'begin' will mean begin a statement block, not a transaction block.

I know that, too. But currently in postgresql begin means the same as begin
work. Correct me if I'm wrong.

Michael

-- 
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

Fri, 20 Mar 1998 13:57:02 +0100 (CET)
Michael Meskes <meskes@topsystem.de>
Re: AW: [HACKERS] Begin statement again