Re: UTL_FILE.put_line() and HEXTORAW()

I don't know how HEXTORAW() works, but we were inserting linefeed or carriage return concatenating with the chr() value. For example;

    v_output_string5 :=
   ' begin'||chr(10)||
   ' select obj_id into v_oid '||chr(10)||
...

    utl_file.putf(v_filehandle, v_output_string5 || chr(10));
...

HTH Received on Fri Apr 21 2006 - 20:37:58 CDT