in reply to Version of DBD::Oracle needed to connect to 9i ?

hi secret,

Firstly check that your ORACLE_HOME environment variable has the correct path. DBD::Oracle uses this to locate the Oracle binaries. Have you recently upgraded from an older version or Oracle?

IMHO it would also be an idea to update both the DBI and DBD::Oracle versions. The Tutorials section has A Guide to Installing Modules by tachyon which I suggest you read if you are not familiar with installing modules.

Hope this helps.

Martin

Replies are listed 'Best First'.
Re^2: Version of DBD::Oracle needed to connect to 9i ?
by secret (Beadle) on May 16, 2006 at 13:44 UTC
    Finally DBD::Oracle has been recompiled in another directory which is called via use lib before use DBI.

    Worth a note is that LD_LIBRARY_PATH needs to include the lib32 directory of Oracle 9i .
    This is set via the shell since it does not seem to work when setting it in %ENV, even from within a BEGIN block.

    Thanks for all the advice !

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom