Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |