Re: PL/SQL: More than 1023 characters without lineterminator

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 07 Apr 1999 21:45:38 GMT
Message-ID: <370bd124.1115045@news.arnes.si>

On Tue, 06 Apr 1999 22:29:27 GMT, srinivasulu.kalicheti_at_hksystems.com wrote:

>How can I create a file , using the UTL_FILE package, which contains more
>than 1023 characters in a row without a lineterminator ?
>Using UTL_FILE I always get an write error on UTL_FILE.PUT_LINE(..).
>
>We are using oracle 8.0.5 on Windows NT.
>
>any help is appreciated.

I belive using UTL_FILE.PUT()+UTL_FILE.NEW_LINE() (as suggested by Bill) won't solve your problem. AFAIK there is no way you can write a line longer than 1023 chars with UTL_FILE prior to Oracle8i. In 8i you can read/write lines as large as 32K.

>Srini

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Apr 07 1999 - 16:45:38 CDT