SQLLDR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQLLDR

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    74
    Can Sql*Loader be invoked from within a program rather than through SQL*PLUS?


    Thanks.

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    Sure, just type in sqlldr (plus whatever parameters you want) from a command prompt.

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    Hi CBW

    Sql*Loader can be invoked from within a pl\sql program! a few months ago i myself have posted a thread in this forum about this more then 6 monthes ago. in the end i had no need to operate an Sql*Loader from pl\sql so i have no code to show and i can not remember how it was doen

    i lookd at the archive and could not find the thread. but, as far as i remember you need to look at dbms_job (and i hope it is not absoulot nonsens...)

    shawish_sababa

    shawish_sababa@hotmail.com

  4. #4
    Join Date
    Aug 2000
    Posts
    462
    Yes. I recently wrote an application which calls SQLLDR from VB Script in an Access application. My app accepts some input from users, outputs data to a text file and loads into Oracle using SQLLDR.

    I suppose I could have used ODBC, but I had a short timeline and tons to do.

    here's the code:

    Shell ("e:\oracle\ora81\bin\sqlldr.exe user/pwd@dbname control=d:\development\test\sqlldr\test.ctl data=d:\development\test\test.txt")


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