Using Windows environment variables?

I would like to use Windows environment variables to
make my schedule portable to other machines ...
I have defined a SYSTEM-level variable pointing to
my Oracle /bin directory, let's say:

ora_path = C:\oracle\ora9i\bin

... and I wish to use this variable in a program run
statement, e.g.

%ora_path%\SQLLDR.EXE parfile='%par_path%\parfile.par' control='%ctl_path%\ctlfile.ctl'

However, not working right now. Is there any way
of doing this?

Thanks!

Kurt Mang
Vancouver, BC Canada

You can create a little batch file containing just %ora_path%\SQLLDR.EXE parfile='%par_path%\parfile.par'
control='%ctl_path%\ctlfile.ctl' command and schedule this batch file to run.

: I would like to use Windows environment variables to
: make my schedule portable to other machines ...
: I have defined a SYSTEM-level variable pointing to
: my Oracle /bin directory, let's say: ora_path = C:\oracle\ora9i\bin

: ... and I wish to use this variable in a program run
: statement, e.g.

: %ora_path%\SQLLDR.EXE parfile='%par_path%\parfile.par'
: control='%ctl_path%\ctlfile.ctl'

: However, not working right now. Is there any way
: of doing this?

: Thanks!

: Kurt Mang
: Vancouver, BC Canada