DBD:Oracle question

Kiran Annaiah <[email protected]> Wed, 30 Jan 2008 10:35:57 -0600
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
Hello,

I have perl program which connects to the Oracle DB. It seems to run fine when i run it from its directory. But when i set up the program as a CRON JOB it fails to run.
Tries to execute but gives this error and quits -

-------------------------------------------------------------------------------------------
Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.10.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
 at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5
Compilation failed in require at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
BEGIN failed--compilation aborted at /home/kiran/projects/ORACLE_TO_MYSQL_table_copy/subject_form/copy_subjFormTable_fromOraToMysql.pl line 5.
--------------------------------------------------------------------------------------------


I do have the Oracle.so shared library file in the location specified above. 
Wondering why it is failing to load, considering that it  program runs fine from its directory.

thank you all
Kiran




_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008