Re: UTL_FILE package question

[Quoted] [Quoted] Thanks. So if there is a length limit for the utl_file, then is there any other way to write a long columns into file in delimited format?

Thank you!

BSB In article <725u8k$f5m$1_at_news.bctel.net>,   "Thor" <none_at_none.net> wrote:
> The documentation states the buffer size is 1023. It does not mention put,
> but it is the same.
>
> for the other replies, varchar2 when used as a table column has a max length
> of 2000, while varchar2 as a pl/sql variable is 32767.
>
> This is a real crappy limit!!
>
> Thor HW
> badstreetboy_at_my-dejanews.com wrote in message
> <71qfjq$seg$1_at_nnrp1.dejanews.com>...
> >Is there a length limit to write to a file using UTL_FILE package? I tried
 to
> >pass in a long varchar2(about 2000 characters) column and it goes to
> >UTL_FILE.Write_Error exception. Any ideas? Thanks!!
> >
> >BSB
> >
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 09 1998 - 00:00:00 CET