perlquestion
Samy_rio
Hi Monks
<br>
My script is working fine in ksh shell command prompt when i ran it as manual.
<br>
<code>
#!/data/opt/pkg/bin/perl
use strict;
use warnings;
use POSIX;
use Data::Dumper;
require DBI;
require DBD::Oracle;
...
...
</code>
<p>but if i schedule it in crontab then i am getting below error.</p>
<code>
Can't load '/data/opt/pkg/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.11.1: cannot open shared object file: No such file or directory at /data/opt/pkg/lib/perl5/5.10.0/x86_64-linux-thread-multi/DynaLoader.pm line 203.
</code>
<p>Also i tried to set environment variable. eventhough its not working from crontab. </p>
<code>
$ENV{'ORACLE_HOME'} = "/data/oracle64/product/11.1.0/client_1";
$ENV{'LD_LIBRARY_PATH'} = $ENV{'ORACLE_HOME'}."/lib:".$ENV{'LD_LIBRARY_PATH'};
</code>
<p>kindly suggest me in correct direction. Thanks in advance</p>
<div class="pmsig"><div class="pmsig-460657">
<p>Regards,<br>Velusamy R.<hr><c>eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';</c></p>
</div></div>