Re: running sqlloader from within plsql

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Sat, 11 Nov 2000 03:22:49 GMT
Message-ID: <dY2P5.24733$Ze6.3509268_at_typhoon.tampabay.rr.com>


Well, you can use dbms_pipe to communicate to the 'outside world' from a db procedure, but if you want a stored procedure to be able to load data from a file, you might find it simpler to use the utl_file package.

SDG <simong_at_explor.co.uk> wrote in message news:CaRO5.593$kn2.725644_at_newsr1.u-net.net...
> Hi,
>
> Is it possible to run sqlloader from within a stored procedure ?
>
> Example
>
> could I run the following from within a procedure
>
> sqlldr80 userid = xxxx/xxxx_at_xxxxx control = cars.ctl log = cars.log bad =
> cars.bad data = cars.dat
>
>
>
Received on Sat Nov 11 2000 - 04:22:49 CET

Original text of this message