What version of DBI/DBD::Oracle are you using?
The most likely reason MySQL works fine is because it did not support
transaction until recently, so everything was automatically commited.
Depending on the version you are using and weather you are using BSD tables,
transaction are most likely not supported.
Ilya
-----Original Message-----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 07/12/2001 9:04 AM
Subject: Commit-Problem
Hi,
as I am new on the list, I try to follow all the rules, if not please
tell me.
While I am using the following comands to change data in an Oracle DB
...
while ($z < $z_max){
$quoteddatum = $dbho3->quote( $mydatum[$z] );
$dbho3->do("UPDATE Wartungstermine
SET Datum = $quoteddatum
WHERE Lfdnummer = $myid[$z]");
$dbho3->commit() or die "Commit hat nicht geklappt!";
$z++;
}
$dbo3->disconnect;
the changed data could only be read from the Oracle after the exit(); of
the perl-script but not while the program is still running.
I have already tried all the possibilties with AutoCommit and so on but
nothing helped. But doing the same with our MySQL I don't have any
problems with the commit.
Any ideas, what I could have forgotten?
Thomas
