Re: UTL_FILE package question

[Quoted] 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
Received on Sun Nov 08 1998 - 00:00:00 CET