Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE.OPEN

Re: UTL_FILE.OPEN

From: patrick <mpprpp_at_yahoo.com>
Date: Wed, 28 Mar 2007 13:20:09 -0400
Message-ID: <460aa3c9$0$97239$892e7fe2@authen.yellow.readfreenews.net>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US