Re: SQLLoader and CR/LF in data

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 2 Feb 1999 10:29:53 +0200
Message-ID: <796d5t$2dc$1@hermes.is.co.za>

Jerry B. wrote in message <36B6433E.11558820_at_netscape.net>...
>
>Is there any way to import files containing CR/LF in the data?

Use the FIX parameter in the Control File - this is assuming that the data is fixed length. If memory serves me, the syntax is something like this:
LOAD DATA
INFILE '*' FIX '320'
INTO ...rest of the control file header..

If you're loading variable length which has CR/LFs in the data then you have a problem. SQL*Loader needs to know -where- a row terminates. Best then is to load the data file into a hex editor and to (hopefully) find exactly what unique character is used as end-or-row terminator.

regards,
Billy Received on Tue Feb 02 1999 - 02:29:53 CST