File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Web Services and the fly likes Execute sqlldr command from java code. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "Execute sqlldr command from java code." Watch "Execute sqlldr command from java code." New topic

Execute sqlldr command from java code.

Ritu Kapoor
Ranch Hand

Joined: Oct 03, 2004
Posts: 102

I am not able to transfer the data from txt to oracle table using sqlldr. If I execute the same command from cmd, it executes fine but does not work if I execute from java code.

Please find the code below

Please help to resolve it.
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13036
Process proc = rt.exec(cmd);

Executes one command line. You appear to have multiple commands you want to run. In that case, I would write a .bat file containing all of those commands and exec() the batch file.

You must also provide for consuming the stdOut and stdErr streams created by the process - see the Process JavaDocs.

I agree. Here's the link:
subject: Execute sqlldr command from java code.
It's not a secret anymore!