Re: Calling SQL*LOADER guri's!!!!

In article <dlscott-1904971746190001_at_user-37kbuuf.dialup.mindspring.com> , David Scott <dlscott_at_mindspring.com> writes
>In article <33432BDD.7D6D_at_dial.pipex.com>, david Low
><davelow_at_dial.pipex.com> wrote:
>
>> One of the fields which is being spooled to a file has a lot of carriage
>> returns in it and when SQL*LOADER reads from the file it thinks each
 carriage return is the start of a new
>> line. This leads to the LOADER failing , is there any easy way round
 this problem.
>>
>You may want to try pre-processing the data file to remove the extraneous
>returns, especially if another character delimits the records. Your
>methodology for this will vary according to platform.
>

You could also try using the CONCATENATE keyword if your logical record consists of a fixed number of physical records i.e there wil always be a fixed number of returns per record.

If the records have some kind of continuation marker, you could try the CONTINUEIF keyword...

Andy

Andy Hardy. PGP key available on request