RE: LF and CR (chr(10)||chr(13)) problem -- problem solved

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" <kluo_at_ONLANE.com> 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
> kluo_at_onlane.com

-- 
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: gkatteri_at_fastmail.fm

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: ListGuru_at_fatcity.com (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).