Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to invoke sql*Loader from PL/SQL?

How to invoke sql*Loader from PL/SQL?

From: Michael Daskaloff <mdaskalo_at_tlogica.com>
Date: Fri, 10 Dec 1999 13:50:46 +0200
Message-ID: <3850E916.884A5C9B@tlogica.com>


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 Fri Dec 10 1999 - 05:50:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US