Re: How to begin a transaction?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 7 Feb 2002 15:15:37 -0000
Message-ID: <3c629a1d$0$8510$ed9e5944@reading.news.pipex.net>

I'd strongly advise you to read the Oracle concepts guide.

Oracle treats all sql statements as part of the same transaction until the user issues a commit; or rollback;

See
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76965/c01intro.htm#9281

for details. (free registration required)

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Carlos Hernández" <ESTONOVALE_at_hotmail.com> wrote in message
news:a3u582$c0$1_at_talia.mad.ttd.net...


> Hi,

>

> I don't know how to begin a transaction in PL/SQL o Developer Forms.

>

> In another languages (case of Visual Basic), can initiate the transaction

> with the BeginTrans of ADO objects. Exists any method or function similar

in


> PL/SQL ?

>

> SQL Server also dispose of function (BeginTran).

>

> Thanks and best regards.

>

> Carlos Hernández

> Barcelona (Spain)

>

>

Received on Thu Feb 07 2002 - 09:15:37 CST