BarbaraFuhrmann
Programmer
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
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