Fwd: utl_file in Oarcle 9i

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Wed, 10 Sep 2008 14:56:24 +0100
Message-ID: <53258cd50809100656x5faf0d9g74d784b78d7d1fc0@mail.gmail.com>


John

Funnily enough I was looking at that this morning. There is a 4th optional max_linesize param to UTL_FILE.FOPEN:

max_linesize

Maximum number of characters per line, including the newline character, for this file. (minimum value 1, maximum value 32767). The default is approximately 1000 bytes.
RTFM! Regards Nigel

2008/9/10 John Dunn <JDunn_at_sefas.com>

 When trying to write a line with more than 1000 characters I get a file
> write error?
> Can it not write more then 1000 characters to a line?
>
> John Dunn
>
> Product Consultant
>
> Sefas Innovation Limited
>
> *We are exhibiting at POST EXPO at London's ExCel centre on
> September 30th, October 1st and 2nd*
>
>
>
> Direct Dial + 44 (0) 117 373 6122
>
> *www.sefas.com*
>
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44
> (0) 117 373 6114 Fax: +44 (0) 117 373 6115
>
> *Sefas Innovation Limited. *Registered No: 3769761 England. Registered
> Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom. VAT
> Registration No: GB 741 5377 32
>
> Unless stated to be non-confidential, this email and any attachments are
> private and confidential and are for the addressee only. Sefas monitors
> e-mails to ensure its systems operate effectively and to minimize the risk
> of viruses. Whilst Sefas has taken reasonable steps to scan this email, it
> does not accept liability for any virus that may be contained in it.
>
> Internet communications are not 100% secure and as such Sefas is not
> responsible for their abuse by 3rd parties, nor for any alteration or
> corruption in transmission.
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 10 2008 - 08:56:24 CDT

Original text of this message