Problem with DBD::Oracle 1.18 on Mac OS X with Oracle Instant Client

Problem with DBD::Oracle 1.18 on Mac OS X with Oracle Instant Client

am 03.10.2006 21:45:55 von Gareth

Hi,

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"