Re: Writing in a file
- From: Alex Octan <alex@xxxxxxxxxxx>
- To: Oracle I List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jul 2010 09:32:10 -0300
Hi Nigel,
Yes, it sounds a good solution for my problem.
I will implement that and see if I face another issue, perhaps not.
Thank you a lot.
Alex
On Thu, Jul 15, 2010 at 04:17, Nigel Thomas
<nigel.cl.thomas@xxxxxxxxxxxxxx>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@xxxxxxxxxxx> 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
>>
>>
>
Other related posts:
