DBD-Oracle

[Stefan Huber]

Hi
I try to install/compile DBD-Oracle for a N-Class Server with Oracle 10G (10.2.0).

PERL: 5.8.8 (SD-Depot)
GCC : 4.0.2

Below is some output:

make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/oracle/product/10.2.0/rdbms/public -I/oracle/product/10.2.0/rdbms/demo -I/oracle/product/10.2.0/rdbms/public -I/oracle/product/10.2.0/plsql/public -I/oracle/product/10.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
In file included from Oracle.c:109:
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI/Driver_xst.h: In function 'dbixst_bounce_method':
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI/Driver_xst.h:12: warning: unused variable 'my_perl'
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI/Driver_xst.h: In function 'dbdxst_bind_params':
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI/Driver_xst.h:50: warning: unused variable 'my_perl'
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI/Driver_xst.h: In function 'dbdxst_fetchall_arrayref':
/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI/Driver_xst.h:80: warning: unused variable 'my_perl'
gcc -c -I/oracle/product/10.2.0/rdbms/public -I/oracle/product/10.2.0/rdbms/demo -I/oracle/product/10.2.0/rdbms/public -I/oracle/product/10.2.0/plsql/public -I/oracle/product/10.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
dbdimp.c: In function 'dbd_discon_all':
dbdimp.c:190: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_db_login6':
dbdimp.c:312: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_db_disconnect':
dbdimp.c:760: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_db_destroy':
dbdimp.c:797: warning: unused variable 'my_perl'
dbdimp.c: In function 'pp_exec_rset':
dbdimp.c:1276: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_st_execute':
dbdimp.c:1655: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_st_execute_array':
dbdimp.c:1859: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_st_finish':
dbdimp.c:2144: warning: unused variable 'Perl___notused'
dbdimp.c: In function 'ora_st_destroy':
dbdimp.c:2237: warning: unused variable 'my_perl'
gcc -c -I/oracle/product/10.2.0/rdbms/public -I/oracle/product/10.2.0/rdbms/demo -I/oracle/product/10.2.0/rdbms/public -I/oracle/product/10.2.0/plsql/public -I/oracle/product/10.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -D_HPUX_SOURCE -fPIC -DUSE_SITECUSTOMIZE -DNO_HASH_SEED -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fno-strict-aliasing -pipe -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
oci8.c: In function 'fetch_cleanup_rset':
oci8.c:608: warning: unused variable 'Perl___notused'
oci8.c: In function 'fetch_func_rset':
oci8.c:632: warning: unused variable 'Perl___notused'
oci8.c: In function 'ora_st_fetch':
oci8.c:1673: warning: unused variable 'Perl___notused'
oci8.c:1680: warning: unused variable 'Perl___notused'
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
gcc +b "/oracle/product/10.2.0/lib32:/oracle/product/10.2.0/rdbms/lib32" -shared -static-libgcc -fPIC Oracle.o dbdimp.o oci8.o +s +n -L/oracle/product/10.2.0/rdbms/lib32/ -L/oracle/product/10.2.0/lib32/ -lclntsh `cat /oracle/product/10.2.0/lib32/ldflags` -lm -o blib/arch/auto/DBD/Oracle/Oracle.sl \
\

gcc: +b: No such file or directory
gcc: /oracle/product/10.2.0/lib32:/oracle/product/10.2.0/rdbms/lib32: No such file or directory
gcc: +s: No such file or directory
gcc: +n: No such file or directory
*** Error exit code 1

Stop.

What is the solution for this problem?

Best regards
Stefan

[Richard T. Malafa]

Stefan,
Same problem except for 64bit libs. same machine. Maybe we can help each other.. My summary file is below..
Regards
Rich

[Dennis Handly]

The errors you are getting are on linker options. You need to prefix each by "-Wl,".

-Wl,+b,/oracle/product/10.2.0/lib32:/oracle/product/10.2.0/rdbms/lib32
-Wl,+s -Wl,+n