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 john...@pharmacy.arizona.edu
To: DBI Users Mailing List dbi-users@perl.org
Subject: Stupid Oracle question
If $dbh is my database handle, to roll back
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:
...@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-rollback(); right?
The DBD::Oracle docs don't explicitly say
--
Bruce Johnson
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 rollback
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 occurs.
You do not