If $dbh is my database handle, to roll back the current transaction I
do: $dbh->rollback(); right?
The DBD::Oracle docs don't explicitly say
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
Bruce Johnson wrote:
Depends if you have |AutoCommit| on or not and if you DB and DBD friver
can do a rollback.
cheers
John Scoles
If $dbh is my database handle, to roll back the current transaction I
do: $dbh->rollback(); right?
The DBD::Oracle docs don't explicitly say
Hi,
Yes. Its in the DBI docs.
Michael
On Thu, 6 May 2010, Bruce Johnson wrote:
Date: Thu, 6 May 2010 11:30:59 -0700
From: Bruce Johnson
To: DBI Users Mailing List
Subject: Stupid Oracle question
If $dbh is my database handle, to roll back the current transaction I do:
$dbh->rollb
On May 6, 2010, at 11:34 AM, John Scoles wrote:
Bruce Johnson wrote:
Depends if you have |AutoCommit| on or not and if you DB and DBD
friver can do a rollback.
I've explicitly turned autocommit off, so I can roll back transactions
if an error occurs.
In the old Oraperl syntax it's:
i
ng
fuer den Inhalt uebernehmen.
> From: john...@pharmacy.arizona.edu
> To: dbi-users@perl.org
> Subject: Stupid Oracle question
> Date: Thu, 6 May 2010 11:30:59 -0700
>
> If $dbh is my database handle, to roll back the current transaction I
> do: $dbh-
Bruce Johnson wrote:
> If $dbh is my database handle, to roll back the current transaction I
> do: $dbh->rollback(); right?
>
> The DBD::Oracle docs don't explicitly say
>
>
You want to look at the DBI pod. The begin_work method starts a txn and
the commit and rollback methods commit or rol
Bruce Johnson wrote:
>
> On May 6, 2010, at 11:34 AM, John Scoles wrote:
>
>> Bruce Johnson wrote:
>>
>> Depends if you have |AutoCommit| on or not and if you DB and DBD
>> friver can do a rollback.
>
>
> I've explicitly turned autocommit off, so I can roll back transactions
> if an error occur