Re: UTL_FILE.PUT_LINE

On Mar 4, 1:36 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Mar 4, 1:18 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>
> > Does UTL_FILE.PUT_LINE have a limitation on the length of the string
> > you are printing to file?
>
> > I have a variable declares, VARCHAR2(4000).  I print it to a log
> > file.  However, I have figured out that if I print more than 1000
> > characters, the procedure just stops......
>
> > Anyone?
>
> Had you taken the time to read the documentation on UTL_FILE you'd
> realize that the FOPEN call accepts a MAX_LINESIZE parameter, which,
> if not supplied, defaults to 1024:
>
> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file...
>
> Examining Example 2 on that page explains much.
>
> The problem, therefore, isn't with the PUT_LINE call but in how you
> opened the file.
>
> David Fitzjarrell

Gollee, he was so thrilled to get the answer he took the time to delete his original post. I guess he was so busy deleting that piece of work that he simply forgot to say, well, 'Thank you'.

What a guy.

David Fitzjarrell Received on Tue Mar 04 2008 - 21:10:32 CST