I have a strange problem when connecting to an Oracle 10 database:
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $rc = system "true";
print "Before: $rc\n";
my $dbh = DBI->connect("dbi:Oracle:", "scott", "tiger");
$rc = system "true";
print "After: $rc\n";
$SIG{CHLD} = 'DEFAULT';
$rc = system "true";
print "Default: $rc\n";
gives the following result:
Before: 0
After: -1
Default: 0
In other words, connecting to the database meddles with the CHLD signal
handler in such a way that it looks as if all subsequent calls to
system() failed.
This is perl 5.8.6 on an AIX 5.2 system (64bit) with DBI 1.46 and
DBD::Oracle 1.16; the Oracle version is 10.1.0.2.0. I never had this
problem with Oracle Versions 8 and 9.
Any ideas?
Peter
--
Peter Marksteiner
Vienna University Computer Center