Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file and newline?

Re: utl_file and newline?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 12 Feb 2003 13:29:09 -0000
Message-ID: <3e4a4c26$0$6272$ed9e5944@reading.news.pipex.net>


apologies.

Its there in 8.1.6.3 as well.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA7034B7C13_at_lnewton.leeds.lfs.co.uk...

> 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.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> 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 - 07:29:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US