sql loader error
I AM TRYING to LOAD data into TABLE test with the following structure
X1 NUMBER(7)
X2 NUMBER(7)
X3 NUMBER(3)
X4 NUMBER(5)
X5 VARCHAR2(75)
X6 NUMBER(17)
X7 NUMBER
X8 VARCHAR2(6)
X9 VARCHAR2(4)
X10 VARCHAR2(15)
X11 VARCHAR2(15)
X12 NUMBER
X13 NUMBER
X14 VARCHAR2(4)
X15 varchar2(2)
SQL LOADER CONTROL FILE SCRIPT
------------------
LOAD data
infile 'E:\OracleProcessing\flatfiles\rate.txt'
badfile 'E:\OracleProcessing\flatfiles\Rate_Change_01_01.bad'
discardfile 'E:\OracleProcessing\flatfiles\Rate_Change_01_01.dis'
TRUNCATE
into table test
(X1 POSITION(001:007) INTEGER external,
X2 POSITION(008:014) INTEGER external,
X3 POSITION(015:017) integer external,
X4 POSITION(018:022) integer external,
--X5 position(023:060) CHAR "UPPER(TRIM(:CUST_NAME))",