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 replaces 0A by 0D 0A

Re: UTL_FILE replaces 0A by 0D 0A

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Sep 2006 09:46:17 -0700
Message-ID: <1158079575.718108@bubbleator.drizzle.com>


Kalle Heuwes wrote:
> Hi, Urs !
>
> Unfortunately it also happens with UTL_FILE.put.
> Besides it is not only appended at the end of a row; it is even
> replaced in the middle of a string:
>
> DECLARE
> lc_filename VARCHAR2 (100) := 'test.txt';
> lt_file UTL_FILE.file_type;
> BEGIN
> lt_file := UTL_FILE.fopen ('EXPORT', lc_filename, 'w');
> UTL_FILE.put(lt_file, 'hgfxxx' || CHR(10) || 'xxxgjhg');
> UTL_FILE.fclose (lt_file);
> END;
>
> Kind regards
> Kalle
>

But ... but ... but Microsoft knows what's best for us.

-- 
Daniel Morgan
Puget Sound Oracle Users Group
Received on Tue Sep 12 2006 - 11:46:17 CDT

Original text of this message

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