Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file
rankeshav_at_yahoo.com wrote:
> I am trying to write a text file using utl_file to write to a file.
>
> I used
> UTL_FILE.FOPEN(v_ftp_folder, v_cms_file, 'w');
> UTL_FILE.PUT(v_outfile_handle, 'X');
> UTL_FILE.FCLOSE(v_outfile_handle);
>
> It is creating the file ok with required contents, but at the end it
> is adding a character chr(10) or '0A'. I do not want to add that
> character. Can somebody please help me how to not add that character.
>
> Thanks in advance,
> Murthy
PUT_LINE appends an operating system specific line terminator. I wasn't aware that PUT did so. What version? Thanks.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Feb 27 2007 - 17:50:56 CST