What version of DBD::Oracle are you using? Are you using dbiproxy?
Please show your connect string - obviously you can XXX out the
User Name and Password, and even the database name if you want.
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
>
>
> > 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
>
>
>
>
>
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
