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

Re: utl_file

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 27 Feb 2007 15:50:56 -0800
Message-ID: <1172620255.122297@bubbleator.drizzle.com>


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.org
Received on Tue Feb 27 2007 - 17:50:56 CST

Original text of this message

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