Re: 7.3.4 on NT: exporting text w/an automated script

You can use Win AT just like you plan on using for your FTP process. Write a batch file that calls sqlplus. That script should also invoke the .sql script you want to run.

HTH,
Brian

Ken Ho wrote:
>
> On Sat, 13 May 2000 03:39:40 GMT, "Greg Kainz" <gregkainz_at_home.com>
> wrote:
>
> >check out http://www.evergreen-database.com in Tim's shared scripts area.
> >I think
> >he still has Gary Dodge's "Unload Table" script there.
> >Greg
> >Ken Ho <hoke_at_gse.harvard.edu> wrote in message
> >news:391c2b98.8203536_at_news.harvard.edu...
> >> What can people recommend for exporting straightforward text data from
> >> a table in Oracle 7.3.4 on Win NT 4 in an automated script? Is there
> >> a command-line way to invoke SQL*PLUS or SQL Worksheet to do so? My
> >> goal is to take that text and FTP it elsewhere in a script using the
> >> WINAT facility.
>
> Thanks. Unload_fixed.sql is still at that site. What do people use
> to *invoke* SQL scripts in a batch file from the DOS prompt?
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================