Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE.OPEN
<srihari.oradev_at_googlemail.com> wrote in message
news:1175095440.706983.5110_at_o5g2000hsb.googlegroups.com...
> On Mar 28, 3:50 pm, "patrick" <mpp..._at_yahoo.com> wrote:
>> Hi All,
>>
>> I'm running an older version of Oracle 8.1.7 and I'm using the UTL_FILE
>> package to create a csv file. However, my file is going to be greater
>> than
>> 10 meg and I keep getting an error message after several rows of data
>> have
>> been written to the file.
>>
>> Thanks
>> Patrick
>
> Can you provide more details.
> What is the error you are getting ? is it for the same row everytime ?
> You may be exceeding the limit for PUT or PUT_LINE.
>
> Thanks,
> Srihari
>
Thanks Srihari. I found my problem wasn't the UTL_FILE, but a cursor issue
in which I assumed an incorrect varchar size.
Received on Wed Mar 28 2007 - 12:20:09 CDT