Perl DBD Oracle on HPUX 11 Compilation problems

[Michael Quinn_1]

Using hpux 11.0
- all latest patches
Oracle 8.1.7
Perl 5.6.1
DBI-1.20
DBD-Oracle-1.10
gcc 3.0

On make for DBD-Oracle getting:
/opt/gcc/bin/gcc -c -I/opt/ims/oracle/product/RDBMS/8.1.7/rdbms/demo -I/opt/ims/
oracle/product/RDBMS/8.1.7/rdbms/public -I/opt/ims/oracle/product/RDBMS/8.1.7/pl
sql/public -I/opt/ims/oracle/product/RDBMS/8.1.7/network/public -I/opt/ims/oracl
e/product/RDBMS/8.1.7/rdbms/demo -I/opt/ims/oracle/product/RDBMS/8.1.7/rdbms/dem
o -I/opt/ims/perl5.6.1/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI -fno-strict-al
iasing -I/usr/local/include -I/opt/gnu/include -O -DVERSION=\"1.10\" -DXS_VERS
ION=\"1.10\" -fpic -I/opt/ims/perl5.6.1/lib/5.6.1/9000/800-hpux/CORE oci7.c
/opt/gcc/bin/gcc -c -I/opt/ims/oracle/product/RDBMS/8.1.7/rdbms/demo -I/opt/ims/
oracle/product/RDBMS/8.1.7/rdbms/public -I/opt/ims/oracle/product/RDBMS/8.1.7/pl
sql/public -I/opt/ims/oracle/product/RDBMS/8.1.7/network/public -I/opt/ims/oracl
e/product/RDBMS/8.1.7/rdbms/demo -I/opt/ims/oracle/product/RDBMS/8.1.7/rdbms/dem
o -I/opt/ims/perl5.6.1/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI -fno-strict-al
iasing -I/usr/local/include -I/opt/gnu/include -O -DVERSION=\"1.10\" -DXS_VERS
ION=\"1.10\" -fpic -I/opt/ims/perl5.6.1/lib/5.6.1/9000/800-hpux/CORE oci8.c
oci8.c: In function `oci_hdtype_name':
oci8.c:118: `OCI_DTYPE_DATETIME' undeclared (first use in this function)
oci8.c:118: (Each undeclared identifier is reported only once
oci8.c:118: for each function it appears in.)
oci8.c:119: `OCI_DTYPE_INTERVAL' undeclared (first use in this function)
make: *** [oci8.o] Error 1

I could swear there was a fix for something like this for 8.1.6 but cannot seem to find my notes.

Anybody fixed these problems with Oracle Libararies?

[Steven Sim Kok Leong]

Hi,

You need the DBD::Oracle 1.12 build. Refer to this thread:

http://archive.develooper.com/dbi-users@perl.org/msg05904.html

Hope this helps. Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com