RE: [HACKERS] Begin statement again

From: "Meskes, Michael" <meskes(at)topsystem(dot)de>
To: "'jwieck(at)debis(dot)com'" <jwieck(at)debis(dot)com>, meskes(at)topsystem(dot)de
Cc: andreas(dot)zeugswetter(at)telecom(dot)at, pgsql-hackers(at)hub(dot)org
Subject: RE: [HACKERS] Begin statement again
Date: 1998-03-13 12:42:38
Message-ID: 11720CEF3853D011AC0C00A024B7A9E11125C0@einstein.topsystem.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)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(at)debis(dot)com [SMTP:jwieck(at)debis(dot)com]
> Sent: Friday, March 13, 1998 1:38 PM
> To: meskes(at)topsystem(dot)de
> Cc: andreas(dot)zeugswetter(at)telecom(dot)at; meskes(at)topsystem(dot)de;
> pgsql-hackers(at)hub(dot)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(at)debis(dot)com (Jan Wieck)
> #

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1998-03-13 12:43:29 Re: AW: [HACKERS] Begin statement again
Previous Message Jan Wieck 1998-03-13 12:38:17 Re: [HACKERS] Begin statement again