Re: SQL*Loader error 524

I had the same problem and I now make sure that I hit return after the last line. Oracle expects a return indicator at the end of line.

Bill West wrote:

> Has anyone encountered an error of this type:
>
> SQL*Loader-524: partial record found at end of datafile (test.ctl)
>
> I am not sure this error refers to the data file or the control file since
> it mentions both. I use this utility frequently and this is the first time I
> encountered the error. It would seem to indicate some missing punctuation at
> the end of the control file but I can't see it. Below is the control file.
>
> LOAD DATA
>
> INFILE 'c:\temp\sdsc\efft_index.csv'
>
> BADFILE 'c:\temp\sdsc\efft_index.bad'
>
> DISCARDFILE 'c:\temp\sdsc\efft_index.dis'
>
> DISCARDMAX 999
>
> REPLACE
> INTO TABLE wwest.effective_index_master
>
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
>
> (ifis_index char,
> effective_date date "dd-Mon-yy",
> title char,
> fund char,
> org char,
> program char,
> refresh_date date "dd-Mon-yy",
> accting_period integer external)
>
> Any help would be greatly apprectiated.
>
> Bill West
> UCSD
Received on Fri Apr 16 1999 - 06:07:06 CEST