Operating System - HP-UX
1830015 Members
2088 Online
109998 Solutions
New Discussion

Re: Control Character added at the end of Line in Oracle Report

 
Victor_101
Regular Advisor

Control Character added at the end of Line in Oracle Report

Hi Guys,
I have an Oracle 9i RAC running on a 11i MSCG.
when i connect to the first instance my report is generated perfectly but when i print to the second instance there are some problems with the beginning of some random lines where the line is moved to the left and subsequently some characters are deleted from the start of the line. Upon viewing the .out file via VI editor the difference noted here is that there is a ^M added to the end of each line that may be causing a confusion to my dinosaur line printer. Where is this ^M being generated from ? is HP-UX doing something to modify this output file ? i guess someone is doin to dos2unix? any ideas?
2 REPLIES 2
Leif Halvarsson_2
Honored Contributor

Re: Control Character added at the end of Line in Oracle Report

Hi,
I belive it is a configuration issue with Oracle, not with HP-UX. You can use tr (or, perhaps dos2ux) to remove the unwanted characters before printing .
Stephen Keane
Honored Contributor

Re: Control Character added at the end of Line in Oracle Report

In DOS, the end of a line is delimited by a carriage return (ASCII 13) and a line-feed character (ASCII 10). In Unix only a line-feed character (ASCII 10) is needed. The ^M you are seeing is a carriage return character (ASCII 13). You can either use tr or dos2ux to get rid of it before printing, or there may be a configuration file that is indicating hard-carriage returns somewhere.