Thread Perl/DBI - Fehler abfangen (2 answers)
Opened by nes at 2005-01-31 15:12

renee
 2005-01-31 15:20
#51431 #51431
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
my $dbh = DBI->connect( "dbi:Oracle:$db_host", $db_user, $db_pass,
) || die "Database connection not made: $DBI::errstr";

$dbh->{RaiseError} = 0;
$dbh->{PrintError} = 0;

my $sth = $dbh->prepare(q{
INSERT into DGKTO_BASIS
( Feld1, Feld2, Feld3, Feld4 )
) values (
?, ?, TO_DATE(?,'YYYYMMDD'), ?
}) || die "Can't prepare statement: $DBI::errstr";
...
# Hauptschleife
...
if($sth->execute ($feld1, $feld2, $feld3, $feld4)){
...
}
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread Perl/DBI - Fehler abfangen