Re: UTL_FILE replaces 0A by 0D 0A

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