Operating System - HP-UX
1834961 Members
1744 Online
110071 Solutions
New Discussion

AutoCommit + Oracle + perl

 
network_4
Advisor

AutoCommit + Oracle + perl

Hi, Anyone having idea how to disable autocommit while executing query with perl. I am using oracle 9i and perl 5.8 but when ever i execute any update query it autocommit.
++++++++++++++++++++++ Below is wht i am doing for disabling it +++++++++++++++==
#!/Opt/perl64/bin/perl
use DBI;
$dbh = DBI->connect('DBI:Oracle:iobastst','nidhitabs','nidhitabs',{AutoCommit => 0}) or die "Couldn't connect to database: " . DBI->errstr;
$dbh->{AutoCommit} = 0;
$sth = $dbh->prepare("nsert into cams_file_mv_status values ('$data1','$!','$data')") or die "Couldn't prepare statement: " . $dbh->errstr;) or die "Couldn't prepare statement: " . $dbh->errstr;
$sth->execute();
1 REPLY 1
Hein van den Heuvel
Honored Contributor

Re: AutoCommit + Oracle + perl

Network,

This is the same question as you asked earlier in:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1115635

You can 'ping' that topic back to the top through a small reply typically "anyone?"

Others,
please reply to original topic

Moderators...
Kill this duplicate topic ?

Hein.