Re: sqlload:2 questions

From: Rob Zwartjes <rzwartje_at_rob.home.nl>
Date: 22 Jan 2001 21:53:06 GMT
Message-ID: <slrn96p4vn.a78.rzwartje@rob.home.nl>

On Sun, 21 Jan 2001 22:48:09 +0100, Sybrand Bakker <postbus_at_sybrandb.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

Thanks Sybrand,

I will lookup that book you mentioned. The option perl was already known to me but working in pl/sql it just crossed my mind why not trying to do it here I mean starting sqlload of course.

Rob> Received on Mon Jan 22 2001 - 15:53:06 CST