Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql*loader (sqlldr) doesn't run via Host on Windows machine and 10g.

589686Jul 24 2007 — edited Apr 25 2011
I'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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2011
Added on Jul 24 2007
5 comments
2,212 views