SQL*Loader error

From: Sankaranarayanan, Ramasubramanian <Ramasubramanian.Sankaranarayanan_at_compaq.com>
Date: Tue, 21 Nov 2000 12:01:13 -0600
Message-Id: <10687.122638@fatcity.com>

Hello Gurus

I got this error when I load the records into the table..It always skip the last record in the file and giving the following erorr.

I appreciate all of your help on that...

Error Message:

SQL*Loader-524: partial record found at end of datafile

CTL File

load data
infile '<filename>'
discardfile '<discardfilename>
append
into table schema_name.tbl_name
WHEN (44:44) = 'Y'

        (FAILURECODE POSITION(2:12) CHAR "ltrim(rtrim(:FAILURECODE))",
         DESCRIPTION POSITION(13:43) CHAR "ltrim(rtrim(:DESCRIPTION))",
         FAILURETYPE CONSTANT "FUNCTIONAL" )

Received on Tue Nov 21 2000 - 12:01:13 CST