in reply to compile problem for DBD::Oracle

yelekeri,

Do you have an Oracle client installed and can you tell us what is in the environment variables ORACLE_HOME and LD_LIBRARY_PATH?

Thanks

Martin

Replies are listed 'Best First'.
Re^2: compile problem for DBD::Oracle
by yelekeri (Novice) on Mar 06, 2007 at 18:09 UTC
    Oracle client is installed on the machine 9.2.0, and I am able to access the database using SQLPLUS.

    Here are my variables for the same :
    ORACLE_HOME /export/apps/oracli/DSM/9.2.0
    LB_LIBRARY_PATH /export/apps/oracli/DSM/9.2.0/lib32

    Also I couldn't locate "oracle.mk" anywhere in the oracle install dir. I never expected it because even in the "working" machine, I don't see oracle.mk file.
        I had the same problem on one of my machines. I still don't know why this one refused to detect the instant client. I got it to work by compiling with "perl Makefile.PL -l". The -l option tells the compiler to try to link to libclntsh directly.