Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12899: value too large for column

User_51476Feb 26 2018 — edited Feb 27 2018

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2018
Added on Feb 26 2018
12 comments
3,814 views