Re: How to run sql*ldr from pl/sql ?

In article <DHH81B.E88_at_cix.compulink.co.uk>, <esha1_at_cix.compulink.co.uk> writes:
> Newsgroups: comp.databases.oracle
> Path:

noc.tor.hookup.net!hookup!uwm.edu!chi-news.cic.net!simtel!zombie.ncsc.mil!news. mathworks.com!newsfeed.internetmci.com!btnet!news.compulink.co.uk!cix.compulink co.uk!usenet
> From: esha1_at_cix.compulink.co.uk ("Mike Ziemann East Su")
> Subject: How to run sql*ldr from pl/sql ?
> Message-ID: <DHH81B.E88_at_cix.compulink.co.uk>
> Organization: Pleasant
> Date: Fri, 3 Nov 1995 16:48:47 GMT
> X-News-Software: Ameol
> Lines: 8
>
> Hi, I would like a pl/sql block to delete a certain amount of records
> from a table and then invoke sql*ldr with passed parameters to load some
> new data into the table. Is there any way of starting sqlldr in this way
> ?
>
> Thanks in advance,
>
> Mike Ziemann

How about:

!sqlload oraid/passwd

(escaping to unix from the SQLPLUS script).

\louis Received on Mon Nov 06 1995 - 00:00:00 CET