SQL Loader - ERROR - Field in data file exceeds maximum length

Hi,

I am getting the following error:
Record 47: Rejected - Error on table MMSC_TMP, column RECORD_NR.
Field in data file exceeds maximum length

This my table MMSC_TMP
Column is RECORD_NR Column datatype is NUMBER of 10

This is my control file (first 5 columns)

EDW_MMSC_ID SEQUENCE(MAX,1) ,
SOURCE_SYSTEM_ID CONSTANT '016' ,
RECORD_NR INTEGER EXTERNAL,
NODE_ID CHAR,
MMSC_ENTITY CHAR,

When I check the internet they asked to add CHAR(4000).


Now I am struck with the syntax. Dont know how to add this CHAR(4000)
RECORD_NR INTEGER EXTERNAL,

revert please

Many thanks

In the controlfile, you need to list first the physical fields in the order in which they appear in the file. Afterwards, list the sequences and constants; for example:

Code:

---

RECORD_NR INTEGER EXTERNAL,
NODE_ID CHAR,
MMSC_ENTITY CHAR,
...etc...(to last field in file record),
EDW_MMSC_ID SEQUENCE(MAX,1) ,
SOURCE_SYSTEM_ID CONSTANT '016' )

---

;)