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: Mark D Powell <Mark.Powell_at_eds.com>
Date: 28 Mar 2007 16:21:31 -0700
Message-ID: <1175124091.784024.187870@r56g2000hsd.googlegroups.com>


On Mar 28, 1:20 pm, "patrick" <mpp..._at_yahoo.com> wrote:
> <srihari.ora..._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.- Hide quoted text -
>
> - Show quoted text -

Patrick, just in case you had not tried or consided it, it is very easy to create delimited files using SQLPlus:

How do I export a database table to a flat file ?

        http://www.jlcomp.demon.co.uk/faq/flatfile.html

HTH -- Mark D Powell -- Received on Wed Mar 28 2007 - 18:21:31 CDT

Original text of this message

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