Re: Writing in a file

On 15 July 2010 08:17, Nigel Thomas <nigel.cl.thomas_at_googlemail.com> wrote:

> Alex
>
> Break the lines up into smaller (< 32k) chunks and write using
> UTL_FILE.PUT. Then use UTL_FILE.NEW_LINE to append the line terminator. See
> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#i996959.
>
>
> Regards Nigel
>
>
> On 14 July 2010 20:07, Alex Octan <alex_at_octan.cz.cc> wrote:
>
>> Hi there,
>>
>> I am facing a problem that seems to be simple.
>> The needed is to write a row in a text file (csv), and depends on the
>> business requirement, I have to concatenate two lines or more and write in a
>> file. This line usually can have more than 32K.
>> What I have done is to use utl_file, but as I have lines with more than
>> 32K, I get an error from Oracle that says the limit has reached.
>>
>> Is there any way to workaround, even using another package or feature??
>>
>> DB version 9i EE
>> AIX OS
>>
>> Thanks in advance for any comment.
>> Alex
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l