On 2010-05-05 20:10:47 +0200, Alexander Foken wrote:
On 05.05.2010 14:24, John Scoles wrote:
That is what I would say you would have to go with as I could not find
a C or C++ interface for it on my quick look at the site. There must
be one someplace though??
Why should there be a C/C++
I've just uploaded the 1.23_5 development release of DBD::ODBC. This
will hopefully be the last release before an official 1.24. Below are
the changes since 1.23. All testing welcome however, once a few smoke
testers have passed this release I am going to move to a full release
fairly quickly as
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 the
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:
that should work.. here is a snippet from
DBD-Oracle-1.24\Oracle.ex\commit.pl which creates the connection handle and
then rolls back with it
# Connect to database
my $dbh = DBI-connect( dbi:Oracle:$inst, $user, $pass,
{ AutoCommit = 0, RaiseError = 1, PrintError = 0 } )
or die
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