Thread

RE: [HACKERS] Begin statement again

Michael Meskes <meskes@topsystem.de> — 1998-03-13T12:42:38Z

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

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

> -----Original Message-----
> From:	jwieck@debis.com [SMTP:jwieck@debis.com]
> Sent:	Friday, March 13, 1998 1:38 PM
> To:	meskes@topsystem.de
> Cc:	andreas.zeugswetter@telecom.at; meskes@topsystem.de;
> pgsql-hackers@hub.org
> Subject:	Re: [HACKERS] Begin statement again
> 
> > 
> > I agree with BEGIN/END being used for PL/pgSQL. But that means I
> have to
> > add it to ecpg to start a block of PL/pgSQL, e.g. to call a stored
> > procedure in ORACLE I need PL/SQL in C.
> > 
> > AFAIK there is no transaction start command in SQL standard anymore.
> > Just issue commit and your transaction is flushed. So either I have
> to
> > remove that feature and go back to explicit transaction start
> commands
> > or BEGIN WORK resp. BEGIN TRANSACTION are useless.
> 
>     But there is AUTOCOMMIT ON/OFF
> 
> 
> Jan
> 
> -- 
> 
> #=====================================================================
> =#
> # It's easier to get forgiveness for being wrong than for being right.
> #
> # Let's break this rule - forgive me.
> #
> #======================================== jwieck@debis.com (Jan Wieck)
> #