Sql*loader (sqlldr) doesn't run via Host on Windows machine and 10g.
589686Jul 24 2007 — edited Apr 25 2011I'm trying to figure this out for a while now ....
I would like to run sqlldr on a windows-server via a Host command in a form. I've created a testform with one button and a when-button-pressed trigger containing:
Host('sqlldr.exe db10g/db10g@orcl control=gnis.ctl log=gnis_mich.log data=my_gnis.dat');
When running this form in the application server, nothing happens!?
And when I run the same command in a .bat-file directly, it does run!
Also putting the batch file in the host command doesn't help.
I've tried some different commands.
Which doesn't work:
Host('loaddata_gnis.bat');
Host('C:\Oracle10G\product\10.2.0\db_1\BIN\sqlldr db10g/db10g@orcl control=C:\OracleAS_F\forms\gnis.ctl log=C:\OracleAS_F\forms\gnis_mich.log data=C:\OracleAS_F\forms\my_gnis.dat');
Host('sqlldr.exe>sqlldr.txt');
Examples which work fine within this environment:
Host('C:\Oracle10G\product\10.2.0\db_1\BIN\tnsping.exe>tnsping.txt');
Host('dir>list.txt', no_screen);
Does somebody know how to solve this or how to debug?
Thanks!