sqlldr in cron is not working

[vv_2010]

Hi all,
would anybody know why am I not able to make the Oracle sqlldr utility work in cron?

I am writing the same thing I would normally write at the prompt, I can see in the cron message at /var/spool/mail/user1 that the command is being processed but it fails with some error message I'm not familiar with:

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found;

Any ideas?
Thanks,
vv

[mdwatts]

That looks like a Oracle error message to me.

What command are you using in crontab?

Try putting the command in a script, make it executable and then run the script from cron.

[vv_2010]

thanks 4 the answer.

i'm not thru, though.

if i stick with:
some_minute some_hour * * sqlldr parfile=/some_path/parameter_file.par in crontab, then I get command not recognized for the bash shell.
but if i provide the whole path some_minute some_hour * * sqlldr $ORACLE_HOME/bin/sqlldr parfile=....
then i get the error message above.

I googled the error and didn't get too much on this. Apparently it's an env problem, but exporting the "correct" values just before cron executed the command didn't help. I'll try putting everything in a script anyway, although I can't understand why would this help. It will probably be yet another one of those things that work but I don't know how and why :o
thanks again,
vv

[vv_2010]

Nah,
still not working...
and if i execute the script at the prompt it works; as soon as i use cron it's serving me the Message 2100 not found, blah, blah.
well, if anybody has any idea...
thanks,
vv