Re: Stupid Oracle question

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:

if ($ora_errstr){
	print "$ora_errstr occurred with $statement";
	&ora_rollback($dbh);
	}
&ora_commit($dbh);

I'm redoing some old scripts to use DBI instead, so I'm guessing the  
equivalent DBI code is:

if ($ora_errstr){
	print "$ora_errstr occurred with $statement";
	$dbh->rollback();
	}
$dbh->commit();

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs