Re: UTL_FILE problem

A "flat file" by definition is nothing more than a text file (usually column delimited). So a flat file is platform independent. If the database server is Unix and you wish to place the flat file on an NT platform, then you'll probably need to do something like:

1. use UTL_FILE to write the file to your Unix platform
2. have a "cron" job on the server check for the existence of the file.
3. If the file exists, have a batch job FTP the file to your NT platform.

HTH,
Brian

suisum_at_ecn.ab.ca wrote:
>
> The UTL_FILE can only write a flat file in the database server. However
> this is not suitable for 3 tier architecture if the database server is
> UNIX and the middle tier is NT.
>
> Have anyone try to use UTL_FILE to write a flat file to other platform? Or
> which tools I can use to produce a flat file?
>
> --
> Best regards,
 

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