Re: SQL*Loader Question

Larry,

Look into the SQL*Loader keyword "continueif". You'll have to pre-process your data but you can load multi-line logical records without hitting the EOL.

Cliff

Larry N. Singh wrote:

> Hi,
>
> I'm trying to load a flat text file into an Oracle Database
> ( 7.2.2 ). The file contains several records each of a
> fixed length ( 100 bytes long ). In every example I've
> seen of using SQL Loader, records were delimited by end-
> of-line. So, when I run SQL*Loader only 1 record is
> inserted into the database. I was wondering if there
> was a way of specifying the record length in bytes.
> I've tried specifying RECSIZE=100, but then it can't
> open the file for some reason.
>
> Thanks very much in advance for any help.
>
> Larry.

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.