I'm having an odd problem occur when running a Perl script from a UNIX cron. This script runs in a user called interface and exists in /home/interface/scripts. After the usual tests for parameters etc the initial action in the Perl script is a chdir into /home/interface/debtors/payroll and a call to SQLPLUS. When running this script interactively from the command line or running it from the ROOT cron there are no problems. Attempting the same run from the interface cron (our system standard) the call to SQLPLUS fails returning a response of 256. Not being a UNIX expert, I'm guessing that this may be a permissions issue caused by the chdir? Anyone else encountered something like this? Any way in Perl to retain the original permissions/environment? If any of this appears particularily daft don't worry about it - I've been having a VERY bad week!
Cheers,
Ronnie Cruickshank