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 +++++++++++++++==
use DBI;
$dbh = DBI->connect('DBI:Oracle:iobastst','nidhitabs','nidhit abs',{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;