Resolving the error,"ORA-12899: value too large for column"?

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"?