Re: SQLLDR problem

From: Laurenz Albe <>
Date: 18 Jul 2008 06:36:08 GMT
Message-ID: <>

Maxim Demenko <> wrote:

> blindsey schrieb:

>> I'm trying to import a fixed-length ASCII file using SQLLDR.
>> The end-of-line is 0D 0A, as usual.

"As usual" is funny.

>> But some notes fields in the data use 0D 0D 0A within them. SQLLDR
>> interprets this as end-of-line.
>> Is there a way I can tell SQLLDR to ignore that sequence or translate
>> it into something else (like a space)?
> Fixed record format?

Or surround the fields with quotes.

Laurenz Albe Received on Fri Jul 18 2008 - 01:36:08 CDT

Original text of this message