Re: Starting SQL Loader from PL/SQL

Allan Martin wrote:

> Does anyone know how to start SQL Loader from a PL/SQL script. I know the
> syntax for running it in DOS, but I'd like to start it from a pl/sql script.
> Is there anyway of starting a program from pl/sql as it would be the same as
> that. Maybe a call to a Java class or something would be the only way to do
> it.
>
> Again, any advice would be great.
>
> Thanks,
> Allan Martin

Allan,

We start SQL Loader (on UNIX) from a PL/SQL script using an Oracle supplied package called DAEMON. We use daemon to invoke a UNIX script, which in turn calls SQL LOADER. You might be able to use the same package to call a dos batch file which would invoke loader.

HTH,
Lisa

--
Lisa McGrath

Lmcgrath_at_uwsa.edu