I had the same problem today; Oracle sqlplus was not found in the crontab Perl script.
I tried like this and it works - the Oracle env. ist initialize in .usr_profile (ksh and not csh):
system (". $ENV{HOME}/.usr_profile; sqlplus -SILENT $dbuser/[EMAIL PROTECTED] << EOF
SELECT SYSDATE FROM DUAL;
EOF"
);
May be it will help you.
Olivier
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: perl/crontab Question Date: Mon, 28 Jul 2003 14:26:31 -0600 (MDT)
This may be a bit off topic, but I'll ask it..
I have a perl job I want to run out of a cron job, However cron is not reading my .cshrc file by default. So what I have to do is "wrap" the perl job in a tcsh shell and then run the shell file out of cron.
Is there a better way? Or maybe the real question is should I be "hardcoding" the var's out of my .cshrc file in my perl script? I think this may be a bad thing to do, but isn't this what I'm doing in the .cshrc file?
Thanks,
Denis
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
MSN Search, le moteur de recherche qui pense comme vous ! http://search.fr.msn.ch
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
