Execute SQL*LOADER from FORM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Execute SQL*LOADER from FORM

  1. #1
    Join Date
    Jul 2001
    Posts
    334

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    What version are you on? How about using an External Table?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jul 2001
    Posts
    334
    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..

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jul 2001
    Posts
    334
    we have 7.3.4.(server) any idea other than 9i(external tables).

    Thanks.

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    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
  •  



Click Here to Expand Forum to Full Width