http://qs321.pair.com?node_id=919509

Samy_rio has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks
My script is working fine in ksh shell command prompt when i ran it as manual.
#!/data/opt/pkg/bin/perl use strict; use warnings; use POSIX; use Data::Dumper; require DBI; require DBD::Oracle; ... ...

but if i schedule it in crontab then i am getting below error.

Can't load '/data/opt/pkg/lib/perl5/site_perl/5.10.0/x86_64-linux-thre +ad-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh +.so.11.1: cannot open shared object file: No such file or directory a +t /data/opt/pkg/lib/perl5/5.10.0/x86_64-linux-thread-multi/DynaLoader +.pm line 203.

Also i tried to set environment variable. eventhough its not working from crontab.

$ENV{'ORACLE_HOME'} = "/data/oracle64/product/11.1.0/client_1"; $ENV{'LD_LIBRARY_PATH'} = $ENV{'ORACLE_HOME'}."/lib:".$ENV{'LD_LIBRARY +_PATH'};

kindly suggest me in correct direction. Thanks in advance

Regards,
Velusamy R.


eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';