Hi,

I'm getting error when I try to call Sqlldr from a batch file:

My batch file look like this:
SQLLDR PARFILE=C:\TMP\mypar.par CONTROL=C:\TMP\mycontrol.txt ........

Someone told to set Oracle Var. but anyway the problem persist.

This the error message:
Message 2100 not found; No message file for product=RDBMS,
facility=ULMessage 2100 not found; No message file for product=RDBMS,
facility=UL

Note: The Oracle database in a machine different where I'm running the
batch.

On Mar 24, 1:26*pm, PowerOne <salazar.wi... (AT) gmail (DOT) com> wrote:
But you DO have your ORACLE_HOME variable properly set?

It would appear not.


David Fitzjarrell

On Mar 24, 1:26*pm, PowerOne <salazar.wi... (AT) gmail (DOT) com> wrote:
But you DO have your ORACLE_HOME variable properly set?

It would appear not.


David Fitzjarrell

On Mar 24, 1:26*pm, PowerOne <salazar.wi... (AT) gmail (DOT) com> wrote:
But you DO have your ORACLE_HOME variable properly set?

It would appear not.


David Fitzjarrell

On Mar 24, 1:26*pm, PowerOne <salazar.wi... (AT) gmail (DOT) com> wrote:
But you DO have your ORACLE_HOME variable properly set?

It would appear not.


David Fitzjarrell

I set it like this:
set $ORACLE_HOME=C:\ORANT\BIN
set $ORACLE_SID=DBNAME

I missed something? or Am I doing something wrong?

I set it like this:
set $ORACLE_HOME=C:\ORANT\BIN
set $ORACLE_SID=DBNAME

I missed something? or Am I doing something wrong?

I set it like this:
set $ORACLE_HOME=C:\ORANT\BIN
set $ORACLE_SID=DBNAME

I missed something? or Am I doing something wrong?

I set it like this:
set $ORACLE_HOME=C:\ORANT\BIN
set $ORACLE_SID=DBNAME

I missed something? or Am I doing something wrong?

PowerOne <salazar.willy (AT) gmail (DOT) com> wrote:
This looks completely wrong.

- Using "set $VAR" to set variable VAR is wrong on every shell I know.
Including MS/DOS.
- C:\ORANT\BIN sounds very much like the wrong location.

Is C:\ORANT\BIN the directory that contains "sqlldr.exe"?

Then you should try:

set ORACLE_HOME=C:\ORANT
set ORACLE_SID=DBNAME

Check that the environment variables are set currectly by using "set".

Yours,
Laurenz Albe