Generating a file from Oracle on Windows with only LF as line terminator
Oracle database release 12.1.0.2.0
Windows 2012R2
I am trying to create a file from the Oracle server with only linefeed chr(10) as the termination character.
utl_file.put_line by definition appends the Windows terminator CR+LF, so I tried using utl_file.put (line || chr(10)) but this is also converted to CR+LF.
Tried converting the string to a RAW variable but this likewise converts to CR+LF.
Can anyone help with this, if only to confirm that it is not possible to do this in Oracle on Windows without post-processing the file to remove the CR characters?
The client for whom this is being written do not want to post-process the file.
Windows 2012R2
I am trying to create a file from the Oracle server with only linefeed chr(10) as the termination character.
utl_file.put_line by definition appends the Windows terminator CR+LF, so I tried using utl_file.put (line || chr(10)) but this is also converted to CR+LF.
Tried converting the string to a RAW variable but this likewise converts to CR+LF.
Can anyone help with this, if only to confirm that it is not possible to do this in Oracle on Windows without post-processing the file to remove the CR characters?
The client for whom this is being written do not want to post-process the file.
0