Hi,
I have built couple of mappings in ODI 12c for which error returned is "ORA-12899: value too large for column"
I have verified following
1) Target data type is same Source data type
2) NLS_LENGTH_SEMANTICS is byte for both
3) In ODI model as well data type and size is same (varchar2 (240))
4) In DB its VARCHAR2(240 CHAR)
5) Data consist of Special Characters like "%"
I tried by using Trim(column_name) and execute on stage. as well as substring but still I am facing same issue
I did check length (in source) for the column ...max is 239 and in error it shows "actual: 245, maximum: 240" , cant understand from where 245 is received.
Any pointers please let me know.
Thanks
Saan