this doesn't seem to work. i have created a simple test script:

#!/usr/local/bin/perl -w
use strict;

foreach (keys %ENV) {
        print "[$_] $ENV{$_}\n";
}
[download]

next i created a .profile file with some oracle environment variables in it.

when i insert the following line in cron:

* * * * * source /opt/home/u_huiar1/.profile;/opt/home/u_huiar1/perl/c
+ron.pl 1>> /opt/home/u_huiar1/perl/output 2>&1
[download]

the file 'output' contains the following lines:

[LOGNAME] u_huiar1
[PATH] /usr/bin:
[SHELL] /usr/bin/sh
[HOME] /home/u_huiar1
[TZ] MET
[download]

somehow it does not have the oracle environment variables in its environment.

arjan huijzer

source is particular to the csh shell (maybe bash/zsh/etc). Perhaps you are using ksh or sh. Try:

* * * * * . /opt/home/u_huiar1/.profile;/opt/home/u_huiar1/perl/c
+ron.pl 1>> /opt/home/u_huiar1/perl/output 2>&1
[download]

ksh and sh use "." (the dot command) to source files.

Thanks! This is what i was looking for.

Arjan