Re: My docs don't have this error: SQL*Loader-524

Richard Billingsley wrote:

> While attempting to create and run a SQL*Loader control file I got the
> following error:
>
> SQL*Loader-524: partial record found at end of datafile
> (st_phone_preload.ctl)
>
> My error docs stop at 523, then jump to 600.
>
> Does anyone know what this error means and how to fix it.
>
> I've counted my load records and they match the size defined.
>
> load data
> infile 'st_phone_data.txt'
> badfile 'st_phone_data.bad'
> into table storm_job_history
> ( empno position(001:009) char,
> beeper position(010:034) char,
> dig_alpha position(035) char,
> da_desc position(036:050) char,
> work_number position(051:085) char,
> alt_work_number position(086:109) char,
> mobile_number position(110:145) char,
> available_storm position(146) char,
> primary_job_code position(147:149) char,
> primary_jog_desc position(150:179) char,
> primary_job_loc position(180:182) char,
> secondary_job_code position(183:185) char,
> secondary_job_desc position(186:215) char,
> secondary_job_loc position(216:218) char,
> primary_effective_date1 position(219:224) date "YYMMDD",
> primary_effective_date2 position(225:232) date "YYYYMMDD")
>
> --
> Richard Billingsley
>
> Note: To reply via email replace "deadend.com" with "vbig.com" before
> sending.

Hallo, Richard.
I had the same error when datafile had in last line EOF character . Delete this line and test again. Received on Mon Mar 13 2000 - 21:46:00 CST