Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> utl_file and newline?
Morning Niall,
in 817 there is an overloaded version of FOPEN which allows you to specify a maximum linesize. I'm not sure if it was introduced in 815, 816 or 817 as I only have the 817 version here (and I've used it !). Otherwise, the maximum is defined as '1023 bytes on most systems'. In 8.0 this was 1022 bytes - so 8i gained an extra byte somewhere :o)
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]
Posted At: Wednesday, February 12, 2003 10:31 AM
Posted To: server
Conversation: utl_file and newline?
Subject: Re: utl_file and newline?
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.
<SNIP> Received on Wed Feb 12 2003 - 05:20:03 CST