| error on load [message #72316] |
Mon, 12 May 2003 10:37  |
Max
Messages: 18
Registered: May 2002
|
Junior Member |
|
|
Hello,
I do not succeed to resolve an error of SQL*Loader: it says to me that the "field in data file exceeds maximum length" when in truth the column is longer.
Not there are errors of double apexes or newline.
Thenk you.
|
|
|
|
| Re: error on load [message #72470 is a reply to message #72316] |
Wed, 25 June 2003 09:49  |
Rajesh Gupta
Messages: 3
Registered: August 2001
|
Junior Member |
|
|
Hello,
If you trying to load a Char, Varchar or Clob field with size greater than 255 characters from a .CSV file (or delimited field) then specify the length of the field with type declaration in control file.
Eg: Control file
LOAD DATA
TRUNCATE
INTO TABLE CCAPS_VERIFICATION_UPLOAD_TEMP
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
C_APPLICATION_NO_R CHAR,
C_VERIFICATION_TYPE_R CHAR,
C_APPLICANT_FNAME1_R CHAR,
C_APPLICANT_MNAME1_R CHAR,
C_APPLICANT_LNAME1_R CHAR,
C_VERIFIER_REMARKS char(2000),
C_SUPERVISOR_REMARKS char(2000)
)
Hope this solves your problem..
Best Regards
Rajesh Gupta
Nucleus Software Exports Ltd.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
