From: "Tom Best" <tom.best@bentley.com>
Subject: Re: Starting a Tranaction
Date: 2000/07/07
Message-ID: <8k557s$426$1@news.bentley.com>#1/1
References: <8k4utf$r8b$1@nnrp1.deja.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Organization: Bentley systems, Inc.
X-MSMail-Priority: Normal
Newsgroups: comp.databases.oracle.server


The way Oracle knows you've started a new transaction, is you issue the
first DLM statement since connecting or commiting or rolling back.

<bilal_z@my-deja.com> wrote in message news:8k4utf$r8b$1@nnrp1.deja.com...
>
>
> I dont suppose questions come any more basic than this:
>
> What the correct sql syntax for starting a tranaction from within a
> script?
>
> I'm using ASP and I've used numerous combinations such as...."begin
> transaction", "begin", "begin select * from....."
>
> and all give me a syntax error.
>
> Can someone please tell me what the correct systax is?
> Thanks much.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.