Hi,
I'm trying to install DBD-Oracle-1.14 on HP-UX 11.11 running Oracle 9.2.0.
The t/ph_type.t test is failed with:
PERL_DL_NONLAZY=1 /opt/perl/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/cursor.....ok
t/general....ok
t/long.......ok
t/meta.......ok
t/ph_type....ok 11/19 expected 'trailing' but got 'trailing ' for VARCHAR2
t/ph_type....FAILED test 12
Failed 1/19 tests, 94.74% okay
t/plsql......ok
t/reauth.....skipped
all skipped: no reason given
t/select.....ok
Failed Test Stat Wstat Total Fail Failed List of Failed
---------------------------------------------------------------------------------------------------------------------------
t/ph_type.t 19 1 5.26% 12
1 test skipped.
Failed 1/9 test scripts, 88.89% okay. 1/314 subtests failed, 99.68% okay.
make: *** [test_dynamic] Error 2
The following is my log information and output of perl -V:
# /opt/perl/bin/perl Makefile.PL -l
Using DBI 1.37 installed in /opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /opt/oracle/app/oracle/product/9.2.0
Oracle version 9.2.0.0.0
Found header files in rdbms/public rdbms/demo.
Found direct-link candidates: libclntsh.sl
Use of uninitialized value in pattern match (m//) at Makefile.PL line 834.
Oracle sysliblist: -lrt -lpthread -l:libnss_dns.1 -ldld
Argument "9.200.0.0" isn't numeric in numeric ge (>=) at Makefile.PL line 846.
***^G
*** Warning: If you have trouble, see README.hpux...
you may have to build your own perl, or go hunting for libraries
***^G
System: perl5.008 hp-ux lsmsdev b.11.11 u 9000800 127494605 unlimited-user
license
Compiler: /opt/ansic/bin/cc +O2 +Onolimit +z -D_HPUX_SOURCE
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae
Linker: /usr/bin/ld
Use of uninitialized value in pattern match (m//) at Makefile.PL line 834.
Sysliblist: -lrt -lpthread -l:libnss_dns.1 -ldld
Linking with -lclntsh.
Warning: If you have problems you may need to rebuild perl with threading
enabled.^G
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -l:libnss_dns.1
LD_RUN_PATH=/opt/oracle/app/oracle/product/9.2.0/lib32
Using DBD::Oracle 1.14.
Using DBD::Oracle 1.14.
Using DBI 1.37 installed in /opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/opt/perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI/Driver.xst > Oracle.xsi
/opt/perl/bin/perl /opt/perl/lib/5.8.0/ExtUtils/xsubpp -typemap
/opt/perl/lib/5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xs
c && mv Oracle.xsc Oracle.c
/opt/ansic/bin/cc -c -I/opt/oracle/app/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/app/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI +z -D_HPUX_SOURCE
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae +O2 +On
olimit -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" +Z
"-I/opt/perl/lib/5.8.0/PA-RISC2.0/CORE" -DUTF8_SUPPORT Oracle.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier
: "sendfile" will have internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier
: "sendpath" will have internal linkage.
/opt/ansic/bin/cc -c -I/opt/oracle/app/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/app/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI +z -D_HPUX_SOURCE
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae +O2 +On
olimit -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" +Z
"-I/opt/perl/lib/5.8.0/PA-RISC2.0/CORE" -DUTF8_SUPPORT dbdimp.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier
: "sendfile" will have internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier
: "sendpath" will have internal linkage.
/opt/ansic/bin/cc -c -I/opt/oracle/app/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/app/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI +z -D_HPUX_SOURCE
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae +O2 +On
olimit -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" +Z
"-I/opt/perl/lib/5.8.0/PA-RISC2.0/CORE" -DUTF8_SUPPORT oci7.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier
: "sendfile" will have internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier
: "sendpath" will have internal linkage.
/opt/ansic/bin/cc -c -I/opt/oracle/app/oracle/product/9.2.0/rdbms/public
-I/opt/oracle/app/oracle/product/9.2.0/rdbms/demo
-I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI +z -D_HPUX_SOURCE
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae +O2 +On
olimit -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\" +Z
"-I/opt/perl/lib/5.8.0/PA-RISC2.0/CORE" -DUTF8_SUPPORT oci8.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier
: "sendfile" will have internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier
: "sendpath" will have internal linkage.
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/opt/oracle/app/oracle/product/9.2.0/lib32" /usr/bin/ld -b
+vnocompatwarnings -L/usr/local/lib Oracle.o dbdimp
.o oci7.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.sl
-L/opt/oracle/app/oracle/product/9.2.0/lib32 -lclntsh -lrt -lpthr
ead -ldld
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/opt/perl/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/opt/perl/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
# /opt/perl/bin/perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=hpux, osvers=11.11, archname=PA-RISC2.0
uname='hp-ux lsmsdev b.11.11 u 9000800 127494605 unlimited-user license '
config_args='-Ubincompat5005 -Duselargefiles -A prepend:libswanted=cl
pthread '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='/opt/ansic/bin/cc', ccflags =' +z -D_HPUX_SOURCE -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -Ae',
optimize='+O2 +Onolimit',
cppflags='-Aa -D__STDC_EXT__ -D_HPUX_SOURCE +z -D_HPUX_SOURCE -Aa'
ccversion='B.11.11.02', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=undef, longlongsize=, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='/usr/bin/ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lcl -lpthread -lnsl -lnm -lndbm -lmalloc -ldld -lm -lc -lndir
-lcrypt -lsec
perllibs=-lcl -lpthread -lnsl -lnm -lmalloc -ldld -lm -lc -lndir -lcrypt
-lsec
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E
-Wl,-B,deferred '
cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Jul 21 2003 10:38:53
@INC:
/opt/perl/lib/5.8.0/PA-RISC2.0
/opt/perl/lib/5.8.0
/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0
/opt/perl/lib/site_perl/5.8.0
/opt/perl/lib/site_perl
.
I have run the same test script on Oracle 8.1.7 using DBD-Oracle-1.14 and
DBI-1.37, It works fine.
Is there a problem with DBD-Oracle and Oracle 9i ?
Yao Huang
VeriSign, Telecommunication Services
Application Services
(360)486-2741
[EMAIL PROTECTED]
