Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing more than 1,000,000 characters with UTL_FILE ?
In fact it is quiet a bit different.
It seems that you can specify the maximum length of a line in the
UTL_FILE.fopen.
By default, it is 1023 characters.
Jerome
"Mark D Powell" <Mark.Powell_at_eds.com> a écrit dans le message de news:
2687bb95.0307280554.7aaa130d_at_posting.google.com...
> "Jérôme VUIBERT" <jerome.vuibert_at_fleximage.fr> wrote in message
news:<3f24f4a7$0$22110$626a54ce_at_news.free.fr>...
> > Hi.
> >
> >
> > Does someone know how to write more than 1,000,000 characters in w file
with
> > the UTL_FILE package, or may i count the length of each writing, then
close
> > the file and reopen it in append mode ?
> >
> > Thanks for you help.
> >
> > Jerome
>
> Our network suffered a hit right when I submitted this so this may be
> a duplicate.
>
> Jerome, I am aware that dbms_output has a 1M output buffer limit, but
> I am unaware of any such limit for utl_file. I took a quick look at
> the exception list and did not see one that seems to apply. Why do
> you think there is such a limitation?
>
> -- Mark D Powell --
Received on Tue Jul 29 2003 - 02:31:23 CDT