Re: Writing in a file
- From: Alex Octan <alex@xxxxxxxxxxx>
- To: Oracle I List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jul 2010 14:56:31 -0300
I got the same error doing the way it was mentioned using UTL_FILE.PUT and
UTL_FILE.NEW_LINE.
I wonder the limit can be from the OS ... in my case is AIX 5.3.
Is if possible?
Thank you.
Alex
On Thu, Jul 15, 2010 at 09:32, Alex Octan <alex@xxxxxxxxxxx> wrote:
> 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:
