How to change linefeed created by UTL_FILE? 1

[BarbaraFuhrmann]

Hello world,

here's my problem:

I have to build an txt-File that contains the input for another software. Each line contains 82 fields separated by '#'. As my oracle 8i database is running under linux (I suppose that this might be the reason for the deferring linefeeds) the linefeed is hex '0A'. The software, that shall process the generated file is running under MS Win2000 and needs hex 'OD OA'. (I figured this out by importing the file with Excel first and saving it as 'txt separated by tabs' without changing anything else. The following software could process the file afterwards.) Is there a solution how I can tell the UTL_FILE procedure to use this needed linefeed?

Thank you
Barbara

 

[skunkmaster]

This is a common problem in unix/windows/dos environments. The simplest way to fix this is to run the unix2dos command in unix(linux) on your text file which will do the conversion for you. There is also dos2unix for the reverse.
The unix2dos command adds a CR whenever it encounters a LF character. If these are not available on your system you can run the commands on Windows to do the conversion. I have seen some internet sites offering freeware for windows versions of these small programs.