VARCHAR2(2000) data type in control file caused "Value Length Beyond The Column Length" error even the data is less in size
Last updated on AUGUST 10, 2017
Applies to:Siebel CRM - Version 220.127.116.11.9 [IP2014] and later
Information in this document applies to any platform.
On : 18.104.22.168.9 [IP2014] version, EIM
Customer trying to load data from csv file to EIM table using sql loader and getting the following error "value length beyond the column length"
Customer column s_evt_act_x.X_CON_ITEM and eim_act_dtl.EXT_X_CON_ITEM are both VARCHAR2(2000).
And also, our value in csv file only about 200 length.
In fact, csv value's length < DB column's length. and error show us "value length beyond the column length".
"value length beyond the column length"
The issue can be reproduced at will with the following steps:
1. Load data using sql loader from CSV to EIM table.
2. error shown as "value length beyond the column length"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms