Thread DBD::ORACLE -> Script bricht ab: Eine Frage zum DBD
(7 answers)
Opened by Tronde at 2003-12-08 15:48
use strict;
use Cwd; # useing the module to work with the directories use DBD::Oracle; use DBI qw(:sql_types); # DBI-Modules my $host=""; my $Oracle_SID=""; my $ORACLE_HOME=""; my $user=""; my $passwd=""; my $error; my $connection="dbi:Oracle:host=$host;sid=$Oracle_SID"; my $db = DBI->connect($connection,$user,$passwd,{PrintError => 0,AutoCommit=>0}); my $shuh = "Update tabelle set q=1000000000 where cust_nb='9999999'"; my $vdh=$db->prepare($shuh); #test $vdh->execute() ; if($vdh->err) { my $errstr=$vdh->errstr; print "\n FAIL ".$errstr." Order : UPDATING tabelle Line in File "; $db->rollback(); $error=1; } $vdh->finish(); $db->disconnect; print "\n $error \n"; TUT was es soll. Habe in einem Längerm Script die selben (!) angaben.. und da macht das Update eben die Probleme... Nichts für ungut renee, aber es hat net geholfen.\n\n <!--EDIT|Tronde|1070899591--> |