Home » SQL & PL/SQL » SQL & PL/SQL » how to call sql loader from pl/sql
icon3.gif  how to call sql loader from pl/sql [message #211671] Sun, 31 December 2006 01:54 Go to next message
patil.vishwa
Messages: 7
Registered: December 2006
Location: Bangalore,India
Junior Member
am trying to call sql loader from pl/sql using execute immediate,but its not working,while searching for solution i got alternates UTL_FILE,External Tables,Dos batch File.

anyone can explain in the detail of the above alternates(atleat one)


thnx in advance
Re: how to call sql loader from pl/sql [message #211676 is a reply to message #211671] Sun, 31 December 2006 03:24 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL*Loader is Oracle utility which is to be run from the operating system command prompt, not SQL*Plus.

I guess that use of external tables would be easier (regarding the fact that your code is written in PL/SQL). For anything more, you'll have to explain what you are trying to do using a few more text lines.

For detailed description and explanation of any of those options would require someone to write another manual, just for you.
As you already know possible options (and keywords), ./fa/1681/0/ or use Google.
Previous Topic: Update table problem
Next Topic: CBO and multiple paths
Goto Forum:
  


Current Time: Sat Dec 03 07:59:38 CST 2016

Total time taken to generate the page: 0.09682 seconds