Re: UTL_FILE Write Error

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 13 Aug 1999 22:30:36 GMT
Message-ID: <37b69c37.6857040@news.siol.net>

On Fri, 13 Aug 1999 19:20:43 GMT, Dawn.Hoffmann_at_reedtech.com wrote:

>Hi,
>
>Question: We are using Oracle 7.3.4 and I am using the UTL_FILE to
>output data to a file. I know there is a limitation of 1023 bytes when
>writing out a record. Does this limitation apply to the PUT and
>PUT_LINE commands even if the PUT is used in a loop (where a chunk of
>data smaller than 1023 bytes) and then a NEW_LINE is used? It happens
>to bomb (with a write error) on a record that has a length greater than
>1023 when the NEW_LINE is used. The write error occurs when the file
>is closed. No record is written.

Yes, it applies also to PUTs in a loop. There is no way you can write a line longer than 1023 bytes, no matter how you combine PUT, PUTF, PUT_LINE or NEW_LINE.

In Oracle8 you can specify a larger max_linesize with FOPEN, though.

>Thanks!
>Dawn

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Aug 13 1999 - 17:30:36 CDT