Re: sqlload:2 questions

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 21 Jan 2001 22:48:09 +0100
Message-ID: <t6mm4ug29p68f1@beta-news.demon.nl>

It is not possible to start sqlloader from pl/sql. It is possible to start it from sq*plus, as it should be possible to start it from

- MS DOS batch files
- Vbscript
- Perl
- Tcl

To mention a few scripting solutions.
2 As per the manual it is possible to replace the infile keyword in the control file with the data= keyword on the command line.

Tip : Guy Harrisson has published a book called the Oracle Desk Reference. This is a one volume manual with the complete sql, pl/sql and tools syntax. Published by Prentice Hall, $34.99, NLG 113.65 and EUR 51.30

Regards,
Sybrand Bakker, Oracle DBA

"Rob Zwartjes" <rzwartje_at_rob.home.nl> wrote in message news:slrn96ml3q.84e.rzwartje_at_rob.home.nl...
> Hello,
>
> I finally got sqlload to work and now I was wandering if the following is
> possible:
> 1 can one start sqlload from within a procedure/function ?
> If this is not the case then my next question becomes irrelavant.
> 2 The infile used for sqlload is going to be a variable. Is it possible to
> start with this part as a variable. At the moment I am using a control
 file
> for starting up sqlload in a form of:
> load data
> infile '/home/robz/yymmdd.csv'
> into table test
> .. etc
> This yymmdd.csv is the variable part. So when it is possible to start
 sqlload
> from within a procedure/function how should I go from here.
>
> Thanks in advance,
> Rob
Received on Sun Jan 21 2001 - 15:48:09 CST