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