I have encountered three problems with the latest (1.14) release of
DBD::Oracle on HP-UX 11 with Oracle 9.2 and perl 5.6.1.
$inspdver{rdbms_ver} contains version number 9.200.0.0. Multi-dot
version number comparison fails on perl 5.6.1. The "hack up a simple
floating point form of the version: 8.1.6 => 8.106" fails.
Bug in Makefile.PL: hpux_libdir() is declared in main::, and called
from both main:: and MY:: without a fully qualified name. This fails
in latter case.
The test for the presence of libqsmashr doesn't take the result of
hpux_libdir() (/.../lib or /.../lib32) into account and believes that
libqsmashr is available in 32-bit builds (there's a lib/libqsmashr.sl
but no lib32/libqsmashr.sl).
*** DBD-Oracle-1.14/Makefile.PL Thu Mar 27 17:44:36 2003
--- /auto/home/ler/perl/DBD-Oracle-1.14/Makefile.PL Wed Sep 10 12:08:22 2003
***************
*** 179,185 ****
}
print "Oracle version $inspdver{RDBMS}\n" if $inspdver{RDBMS};
# hack up a simple floating point form of the version: 8.1.6 => 8.106
! ($inspdver{rdbms_ver} = $inspdver{RDBMS}) =~ s/^(\d+\.\d+)\.(\d+)/${1}0$2/;
#print "\ninspdver{rdbms_ver}=". $inspdver{rdbms_ver} ."\n";
# Check for symbol table problem in libclntsh.dylib.9.0 on MacOS X
--- 179,188 ----
}
print "Oracle version $inspdver{RDBMS}\n" if $inspdver{RDBMS};
# hack up a simple floating point form of the version: 8.1.6 => 8.106
! $inspdver{RDBMS} =~ m/^\d+\./g;
! $inspdver{RDBMS} =~ s{\G(\d+)\.?}{sprintf "%02d", $1}ge;
! $inspdver{rdbms_ver} = $inspdver{RDBMS};
!
#print "\ninspdver{rdbms_ver}=". $inspdver{rdbms_ver} ."\n";
# Check for symbol table problem in libclntsh.dylib.9.0 on MacOS X
***************
*** 294,300 ****
my $libdir = 'lib';
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
! $libdir = hpux_libdir();
}
$opts{LIBS} = [ "-L$OH/$libdir -l$lib $syslibs" ];
$opts{dynamic_lib} = { OTHERLDFLAGS => "$::opt_g" };
--- 297,303 ----
my $libdir = 'lib';
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
! $libdir = ::hpux_libdir();
}
$opts{LIBS} = [ "-L$OH/$libdir -l$lib $syslibs" ];
$opts{dynamic_lib} = { OTHERLDFLAGS => "$::opt_g" };
***************
*** 329,335 ****
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
! my $libdir = hpux_libdir();
$linkwith =~ s!/lib\b!/$libdir!g;
$libhome =~ s!/lib\b!/$libdir!g;
#print "linkwith=$linkwith\n";
--- 332,338 ----
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
! my $libdir = ::hpux_libdir();
$linkwith =~ s!/lib\b!/$libdir!g;
$libhome =~ s!/lib\b!/$libdir!g;
#print "linkwith=$linkwith\n";
***************
*** 442,449 ****
# someone else will have to hack that one out)
$linkwith =~ s/\+D[AS]2\.0[W]* / /g;
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
- my $libdir = hpux_libdir();
$linkwith =~ s!/lib\b!/$libdir!g;
#print "linkwith=$linkwith\n";
}
--- 445,452 ----
# someone else will have to hack that one out)
$linkwith =~ s/\+D[AS]2\.0[W]* / /g;
#Lincoln: if hpux, pick the right library path
+ my $libdir = ::hpux_libdir();
if ( $os eq 'hpux' and $osvers >= 11 ) {
$linkwith =~ s!/lib\b!/$libdir!g;
#print "linkwith=$linkwith\n";
}
***************
*** 453,459 ****
# library loader) libqsmashr defines LhrStringInsert()...
# other libraries may have to be added (Lincoln Baxter <[EMAIL PROTECTED]>)
# we check for the library's existence first... (8.0.5 does not have it)
! if ( -r "$OH/lib/libqsmashr.sl" ) {
$linkwith =~ s/$/ -lqsmashr/ if ( $linkwith !~ m/-lqsmshr/ );
}
--- 456,462 ----
# library loader) libqsmashr defines LhrStringInsert()...
# other libraries may have to be added (Lincoln Baxter <[EMAIL PROTECTED]>)
# we check for the library's existence first... (8.0.5 does not have it)
! if ( -r "$libdir/libqsmashr.sl" ) {
$linkwith =~ s/$/ -lqsmashr/ if ( $linkwith !~ m/-lqsmshr/ );
}
***************
*** 1335,1341 ****
$ldrp ||= "$OH/lib:$OH/rdbms/lib";
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
! my $libdir = hpux_libdir();
$ldrp =~ s!/lib\b!/$libdir!g;
#print "ldrp=$ldrp\n";
}
--- 1338,1344 ----
$ldrp ||= "$OH/lib:$OH/rdbms/lib";
#Lincoln: if hpux, pick the right library path
if ( $os eq 'hpux' and $osvers >= 11 ) {
! my $libdir = ::hpux_libdir();
$ldrp =~ s!/lib\b!/$libdir!g;
#print "ldrp=$ldrp\n";
}
--
Jean-Louis Leroy