> What version of DBI/DBD::Oracle are you using?
I am using version of DBD 1.07 for Oracle
> 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.
Yes, first I was running it with AutoCommit =>1 like with the MySQL
but this also didn't work.
It just should be a simple data update without huge transaction
"comfort".
-----Original Message-----
...
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
