Re: Automate SQL Loader in Windows NT...??

Hi there.

This method exposes username and password in a .cmd file. I reckon it's better to be able to automate external programs from within the database using DBMS_JOB and a mechanism to spawn external processes from PL/SQL. As it happens, I have written such a tool that can call any external process and even wraps SQL*Loader for PL/SQL. The C code has been written for Windows but could easily be ported to other OSs. Please let me know if you're interested.

Cheers,

Finn

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0207222329.252182ce_at_posting.google.com...
> cohens_at_bestweb.net (Eli) wrote in message
 news:<899d7e4d.0207220923.60af7ed4_at_posting.google.com>...
> > I am working in a Windows NT environment and am currently developing a
> > script to be run in Oracle 8i. One of my base tables consists of an
> > email_address column and a count_distinct_email_address column. I am
> > currently manually uploading the tab delimited file using SQL Loader -
> > one click (I created a short cut with the command line opening Loader
> > and pointing to the .ctl and .log file). The problem is, I have to
> > perform two steps. Upload the file using SQL Loader, and then run the
> > script in order to create my final results.
> >
> > Does anyone know of a way to automatically run SQL Loader from within
> > my .sql (script) file?
> >
> >
> > Thanks!
> >
> > Eli
>
>
> NT has a batch facility. Write a short .cmd file and submit it through
> the AT command and you are set. The scheduling service must be running
> for this to happen.
> You can call both sqlloader and sqlplus in your .cmd file
>
> Hth
>
> Sybrand Bakker,
>
> Senior Oracle DBA
Received on Tue Jul 23 2002 - 10:27:11 CEST