Kitty , it is nice on your part to share the solution with the list. For future : (On the lines of what Stefan said) May be dd if=inputfile of=outputfile conv=ebcdic/ebcdicb/ibm/ibmb might have helped. Check with "man dd".
The suggestion given by Raj is worth keeping in mind. HTH GovindanK On Fri, 14 Nov 2003 08:34:25 -0800, "Kitty Luo" <[EMAIL PROTECTED]> said: > > Hi List, > > Finally, I used HexCmp and found out the file generated by Oracle PLSQL > or report writer only contains a CR (chr(13)) even if I had a chr(13) and > chr(10) in the query. > > I re-wrote my export scripts in java, then resulting file is OK. > > Thanks to all of you who responded my problem. > > Have a great weekend! > > Kitty > -----Original Message----- > Sent: Friday, November 14, 2003 9:09 AM > To: Multiple recipients of list ORACLE-L > > > Kitty, > > when the file is written by pl/sql note its size. Then open and save in > notepad and note its size. If both sizes are different, you know there is > a CR/LF problem, else problems is somewhere else. > > Raj > -------------------------------------------------------------------------------- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -----Original Message----- > Sent: Friday, November 14, 2003 8:54 AM > To: Multiple recipients of list ORACLE-L > > > Joze, > > It's not that simply. I already tried all the possible combination: > chr(13)||chr(10) , chr(10)||chr(13), chr(13) , chr(10)||chr(10)... > > Thanks for your input anyway. > > Regards, > Kitty > -----Original Message----- > Sent: Friday, November 14, 2003 6:09 AM > To: Multiple recipients of list ORACLE-L > > > The solution is simple. The correct sequence of characters is not > chr(10)||chr(13) but rather chr(13)||chr(10). This is obviously changed > by notepad. > > regards, Joze > > -----Original Message----- > Sent: Friday, November 14, 2003 5:59 AM > To: Multiple recipients of list ORACLE-L > > > > Hi, > > Currently I am working on a project that requires me to transfer > "Customer Master Record" data into SAP R/3 system from my oracle > database (9.2.0.4 running on Solaris 5.9). The text file (contains LF > and CR) generated by PLSQL or Oracle reporter builder could not be > loaded into the SAP database (running on the same version of oracle > database on W2K). It breaks on the CR. However, when I open the text > file by notepad, do nothing, just simply save the file, re-run the data > load, then everything works fine. Does anyone know anything about this? > Please help. > > Thanks in advance. > > Kitty Luo > Oracle DBA, OCP > Onlane Inc. > www.onlane.com > [EMAIL PROTECTED] -- http://www.fastmail.fm - Faster than the air-speed velocity of an unladen european swallow -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
