Re: HELP w/ PL/SQL writing to a flat file.

On 12 Nov 1997 23:42:07 GMT, cybersaurn_at_aol.com (CyberSaurn) wrote:

[SNIP]
>On the flip side it is A LOT of data -- millions of rows to be processed --
> very long record lengths to be output too (and 500,000 records?) But there is
> minimal formatting. Run a query, output tab-delimited columns to flat file,
> run a query, append additional records, run a query.... And we will run batch
> overnight.
>

If you have very long records, then using UTL_FILE will not be an option for you, as it limited to a maximum line length of 1023 bytes when creating a flat file.

Regards,
Peter

Peter Schneider
pschneider.ctj_at_metronet.de Received on Thu Nov 13 1997 - 00:00:00 CST