Hello,
Just wanted to share what I did to compile and install DBD::Oracle on HP-UX
This is the version of the OS/software I am using:
HP-UX B.11.00 A 9000/82
Oracle8 Enterprise Edition Release 8.0.6.3.0 - Production
DBI-1.32
DBD-HP-UXOracle-1.12
gcc (GCC) 3.2
perl v5.80 (see details below)
when running make, I had problem with the oci8.c file,
I was getting the following errors:
oci8.c: In function `oci_hdtype_name':
oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' undeclared (first use in this function)
oci8.c:100: (Each undeclared identifier is reported only once
oci8.c:100: for each function it appears in.)
oci8.c:109: `OCI_DTYPE_LOCATOR' undeclared (first use in this function)
and a ton of warnings :
oci9.c: ... warning: passing arg 1 of `fprintf' from incompatible pointer
type
I commented out those two lines in oci8.c :
100 /* case OCI_HTYPE_SUBSCRIPTION: return ...
109 /* case OCI_DTYPE_LOCATOR: return ....
After I was able to compile and install the package afterward,
When I run the 'make test' command, it returns some errros (see below)
I wrote a little test script and it could connect and retrieve data from the
Oracle
database.
As I ran into those small problems I am wondering if something is missing
on my system
or if the next release of the DBD::Oracle package should be updated
accordingly.
Regards,
Johan BURATI
----------------------------------------------------------------------------
-----------------------
#!/usr/bin/perl
#
use strict;
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:mydb', 'scott', 'tiger',
) || die "Database connection not made:
$DBI::errstr";
my $sql = qq{ select banner from v\$version }; # Prepare and execute
SELECT
my $sth = $dbh->prepare($sql);
$sth->execute();
my($tname);
$sth->bind_columns(undef, \$tname);
while( $sth->fetch() ) { print "$tname\n"; }
$dbh->disconnect;
----------------------------------------------------------------------------
-----------------------
# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/base.......ok
t/general....ok
t/long.......ok 6/143Use of uninitialized value in string eq at t/long.t
line 153.
t/long.......ok 7/143Use of uninitialized value in length at t/long.t line
153.
t/long.......ok 8/143Use of uninitialized value in length at t/long.t line
345.
Use of uninitialized value in string eq at t/long.t line 346.
# failed test 9 at line 153. Strings are of different lengths (0 vs 20), Len
0
Use of uninitialized value in string eq at t/long.t line 155.
Use of uninitialized value in length at t/long.t line 155.
t/long.......NOK 9Use of uninitialized value in length at t/long.t line 345.
Use of uninitialized value in string eq at t/long.t line 346.
# failed test 10 at line 155. Strings are of different lengths (0 vs 20),
Len 0
t/long.......ok 14/143# failed test 16 at line 175. ORA-01801: date format
is too long for internal buffer (DBD ERROR: OCIStmtFetch)
t/long.......ok 140/143
Some tests for LONG data type handling failed. These are generally Oracle
bugs.
t/long.......ok 141/143Please report this to the dbi-users mailing list, and
include the
t/long.......ok 142/143Oracle version number of both the client and the
server.
t/long.......ok 143/143Please also include the output of the 'perl -V'
command.
(If you can, please study t/long.t to investigate the cause.
Feel free to edit the tests to see what's happening in more detail.
Especially by adding trace() calls around the failing tests.
Run the tests manually using the command "perl -Mblib t/long.t")
Meanwhile, if the other tests have passed you can use DBD::Oracle.
t/long.......FAILED tests 9-10, 16
Failed 3/143 tests, 97.90% okay
t/ph_type....ok
t/plsql......ok
t/reauth.....skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
t/long.t 143 3 2.10% 9-10 16
1 test skipped.
Failed 1/6 test scripts, 83.33% okay. 3/281 subtests failed, 98.93% okay.
*** Error exit code 2
----------------------------------------------------------------------------
--------------------------
# perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC2.0
uname='hp-ux a5 b.11.00 u 9000800 512770508 unlimited-user license '
config_args='-des'
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='gcc', ccflags
='-mpa-risc-2-0 -D_HPUX_SOURCE -fno-strict-aliasing -I/usr/local/include -D_
LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_HPUX_SOURCE -mpa-risc-2-0 -D_HPUX_SOURCE -fno-strict-aliasing -
I/usr/local/include'
ccversion='', gccversion='3.2 20020801 (prerelease)',
gccosandvers='hpux11.00'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, 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 -lgdbm -ldb -lmalloc -ldld -lm -lc -ln
dir -lcrypt -lsec
perllibs=-lcl -lpthread -lnsl -lnm -lmalloc -ldld -lm -lc -lndir -lcrypt -ls
ec
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='-fPIC', lddlflags='-b -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Aug 2 2002 15:25:07
@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
----------------------------------------------------------------------------
--------------------------
