Resolving the error,"ORA-12899: value too large for column"?
book
Article ID: KB0089191
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database
-
Not Applicable
-
Description
Resolution: Description =========== Oracle database error message ORA-12899: value too large for column "Column_Name" is thrown in the adapter log.
Symptoms ========= The error message in the adapter log file is: DBError: 5 ErrorCode: HY000 ServerCode: 12899 Message: [TIBCO][ODBC Oracle Wire Protocol driver][Oracle]ORA-12899: value too large for column "Column_Name" (actual: 12592, maximum: 40)
Environment ========== Oracle Database
Cause ===== This is a database error message which indicates that the value inserted into "Column_Name" is wider than the maximum size defined for the table.
Resolution ======== 1). Please ensure the value inserted into "Column_Name" is within the table definition.
2). Please verify if the issue can not be reproducible.
3). Please check if the Oracle database version is 10.2.0.4 .
It is an Oracle10.2.0.4 defect if meet all above three conditions. Please contact Oracle Support to apply the product patch to resolve the issue.
Issue/Introduction
Resolving the error,"ORA-12899: value too large for column"?