Problem with DBD::Oracle 1.18 on Mac OS X with Oracle Instant Client
am 03.10.2006 21:45:55 von GarethHi,
I'm having some trouble getting the DBD::Oracle 1.18 driver working
on my Mac (OS X 10.4.8). 'Make' works ok but when I run 'make test' I
receive the following errors:
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................Failed to load Oracle extension and/or shared
libraries:
install_driver(Oracle) failed: Can't load '/Users/garethcurtis/
Desktop/DBD-Oracle-1.18/blib/arch/auto/DBD/Oracle/Oracle.bun dle' for
module DBD::Oracle: dlopen(/Users/garethcurtis/Desktop/DBD-
Oracle-1.18/blib/arch/auto/DBD/Oracle/Oracle.bundle, 2): Symbol not
found: _OCILobGetLength
Referenced from: /Users/garethcurtis/Desktop/DBD-Oracle-1.18/blib/
arch/auto/DBD/Oracle/Oracle.bundle
Expected in: dynamic lookup
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/01base.t line 19
The remaining tests will probably also fail with the same error.
.....and obviously all of the other tests do indeed fail with the same
error!
I have looked at the README, README.help.txt and README.macosx files
but cannot seem to see any coverage of the above problem - apologies
if the above is covered though.
Can anyone help/offer advice?
Sqlplus works fine and I can connect to my remote DB.
More info is included below.
Thank you in advance to anyone able to offer their time.
Regards,
Gareth.
Other info:
Oracle Instant Client all packages installed to /oracle/instantclient
DBI version is 1.52
Perl is v5.8.6 built for darwin-thread-multi-2level (installed by
default)
Gcc version 4.0 (installed by default)
The following environment variables are set:
DYLD_LIBRARY_PATH="/oracle/instantclient"
ORACLE_HOME="/oracle/instantclient"
PATH="/oracle/instantclient:/bin:/sbin:/usr/bin:/usr/sbin"
SQLPATH="/oracle/instantclient"
TNS_ADMIN="/oracle/instantclient"