Re: DBD:Oracle question

Off the top of my head I would say it is a permission error or your 
environment variables are not set.  When running from Cron you do not 
have the values in you .proflile set so you will have to set them in the 
.pl  you will need I think ORACLE_HOME and LD_LIBRARY_PATH to be set in 
you program

Kiran Annaiah wrote:
> 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
>   

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]