Execute SQL*LOADER from FORM

[aph]

Hi,
I have developer/2000 Form installed on my (client) machine. We have UNIX/AIX based server where I have already built a sql*loader program (*.ctl & data file) now I want to execute when_button_pressed trigger/button from my machine which invoke sql*loader from server. Using HOST command.
The problem is, what syntax I will use in HOST in order to invoke sql*loader /server side.

* Dev/2000 Forms(my machine) and Sql*Loader & data file on server.

Thanks in advance.

[slimdave]

What version are you on? How about using an External Table?

[aph]

Thanks,
version of D2K Forms 6.0. no idea what is a external table and how it works.
Can u please help with little detail.


Thanks..

[slimdave]

External Table is an Oracle 9i feature, where a flatfile can be queried using SQL directly from the Oracle Server. It works through SQL*Loader ctl definitions still, but you dont need to execute sql*loader from the server o/s to use it

[aph]

we have 7.3.4.(server) any idea other than 9i(external tables).

Thanks.

[TomazZ]

I think you should forget about sql*loader.
Try to use UTL_FILE package instead.
You will have to manually parse data, though.