Re: How to invoke sql*Loader from PL/SQL?

Hi, I have only used SQLLoader via SQL*Plus via HP-Unix terminal, I use it to load external crafted files into Tables. I too would like to know if ther eis a way to execute it through PL/SQL, but I'm not wanting to do anything quite so fancy as you. I'm just loading tables with ASCII files. Thx, Q MailTo:jpquinn_at_home.com

Michael Daskaloff wrote:

> Hi all,
> I'd be very happy if someone can offer me a way to invoke SQL*Loader
> from
> Stored PL/SQL on Oracle8 on HP-UX.
> If someone has already done this I'll be very hapy to know how.
>
> I have an idea to create an external library and invoke some procedure
> written in C,
> which creates a control file and execs SQL*Loader. Does someone know is
> this possible. If someone has already done this can you give me some
> advice (or better - sources if not too offensive).
>
> Thanks in advance.
> Michael Daskaloff
Received on Sat Dec 11 1999 - 14:37:49 CST