Re: UTL_FILE -- creating a carriage return line feed running in UNIX

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 26 Feb 2003 00:54:10 GMT
Message-ID: <Xns932DABF405631SunnySD@68.6.19.6>

dbursey_at_bentley.edu (Donna B.) wrote in news:3596ce2b.0302250533.2dde01cb_at_posting.google.com:

> Hi, all -- I have a UTL_FILE script that creates a csv from an Oracle
> table. So far, so good -- until we get to the end of the record.
> Because the script is running in UNIX, the NEWLINE (linefeed) that is
> included with the PUT_LINE function is not coming out in the csv, so
> when the vendor (who's running on a SQL Server 2000 platform) looks at
> it, it's just one long run-on record. Is there any way to fix this?
> I've looked at the UTL_FILE documentation in the PL/SQL Programming
> book, but no joy. And I am definitely no expert in UTL_FILE anyway.
> Gurus?
>
> Thank you --
>
> Donna

After the file gets created run in thru "unix2dos". Received on Tue Feb 25 2003 - 18:54:10 CST