need help again.......

[thg]

hi,

I have these lines in a load.cmd file


SQLLDR CONTROL=C:\codes\bcp\oracle\load.ctl, LOG=bar.log, BAD=baz.bad, DATA=C:\codes\bcp\oracle\data.csv,
userid=system@RESEARCH/manager
pause


I don't understand why it always ask me for username and password everytime when I execute the .cmd file. This is not what I wated becasue I need to execute the command in my java code.


thg.

[marist89]

SQLLDR CONTROL=C:\codes\bcp\oracle\load.ctl, LOG=bar.log, BAD=baz.bad, DATA=C:\codes\bcp\oracle\data.csv,
userid=system/manager@RESEARCH
pause

[thg]

try it, didn't work. It still ask me for user name and password

[mary]

What Jeff proposed should've worked. I've done it hundreds of times. Are you sure you're entering correct username and password? Check your spelling.

[mary]

Ops. It wasn't Jeff. It was Marist89. I confused him/her with Jeff Hunter for some reason.
Anyway..One thing I missed. Try typing your command without separating commas.
Example:
SQLLDR CONTROL=C:\codes\bcp\oracle\load.ctl LOG=bar.log BAD=baz.bad DATA=C:\codes\bcp\oracle\data.csv userid=system/manager@RESEARCH
Sometimes you need to specify sqlloader version, i.e. 73, 80, 8i, etc.
Example:
SQLLDR73 CONTROL=C:\codes\bcp\oracle\load.ctl LOG=bar.log BAD=baz.bad DATA=C:\codes\bcp\oracle\data.csv,
userid=system/manager@RESEARCH

This shoul work.
If it doesn't post your error message here. We'll figure it out.

[sreddy]

:) Jeff Hunter alias marist89

[marist89]

[QUOTE][i]Originally posted by mary [/i]
[B]Ops. It wasn't Jeff. It was Marist89. I confused him/her with Jeff Hunter for some reason.
[/B][/QUOTE]
We always get confused...

[thg]

Thanks. It works now.