-
Execute SQL*LOADER from FORM
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.
-
What version are you on? How about using an External Table?
-
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..
-
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
-
we have 7.3.4.(server) any idea other than 9i(external tables).
Thanks.
-
I think you should forget about sql*loader.
Try to use UTL_FILE package instead.
You will have to manually parse data, though.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|