Re: utl_file and newline?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 12 Feb 2003 10:30:34 -0000
Message-ID: <3e4a2247$0$14162$ed9e5944@reading.news.pipex.net>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3E4A06CC.69A0_at_yahoo.com...
> imho 32k is a pretty reasonable line width limit.

IIRC that limit is the 9i limit and is,as you say reasonable. I believe that in 8i the limit was closer to 1k. Also as of 9i you can specify your linesize in you call to FOPEN.

My understanding is that UTL_FILE actually calls underlying os calls to do its file handling which *may* explain why writing a file on a windows server with UNIX style linefeeds would be problematic, and *might* also explain what happens with fclose.

corrections and clarifications more than welcome.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Wed Feb 12 2003 - 04:30:34 CST