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

From: Bill Frost <Bill.Frost_at_NOSPAM.hpa.com.au>
Date: Wed, 7 Apr 1999 09:55:21 +1000
Message-ID: <7ee6vi$s9m$1@m2.c2.telstra-mm.net.au>

Use utl_file.put() and utl_file.new_line() instead of utl_file.put_line().

:)BF

<srinivasulu.kalicheti_at_hksystems.com> wrote in message news:7ee1rs$nes$1_at_nnrp1.dejanews.com...
> 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.
>
> Srini
>
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 06 1999 - 18:55:21 CDT