PL/SQL (MOSC)

MOSC Banner

Generating a file from Oracle on Windows with only LF as line terminator

in PL/SQL (MOSC) 4 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center