Re: How do you call SQL-Loader from a PL/SQL procedure?

From: <wfrye_at_my-dejanews.com>
Date: 1998/05/18
Message-ID: <6jo2du$77a$1@nnrp1.dejanews.com>#1/1

In article <6jiai9$kgb4_at_svlss.lmms.lmco.com>, RichardH_at_vorlon.hsv.lmsg.lmco.com (Richard Hollingsworth) wrote:
>
> I need to call sqlldr80 from my pl/sql proc, but just...
>
> sqlldr80 username/password controlfile.ctl
>
> dosen't seem to work.
>
> So, how do you call sqlldr80 from a pl/sql procedure?
>
> Thanx much,
>
> Richard Hollingsworth
>
>

I don't know your operating system. The ones I've worked in all had a command (say xxx) which executed an OS command. Then use

xxx sqlldr80 username/password controlfile.ctl. I;ve used a coomand file in UNIX, but can't remember the details.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 00:00:00 CDT