Your environment in your cron job is not the same as it is in your shell session. You need to set the Oracle-specific environment variables in your cron job as well. A common way is to use a wrapper shell script that also loads your .profile before launching Perl:

#!/usr/bin/ksh
. ~/.profile
exec /opt/perl/bin/perl -w /home/vaish/bin/myscript.pl ...
[download]