Support Article
ORA-12899: value too large for column
SA-47055
Summary
ORA-12899 occurs while deploying a JAR file.
Error Messages
A Problem occurred during import: ORA-12899: value too large for column "CLAWS_PEGA_RULES"."PR_INDEX_REFERENCE"."PXRULEFAMILYNAME"
Steps to Reproduce
Unknown
Root Cause
The field was defined as VARCHAR2(128) and Oracle used up to 32 bytes for storage. However, 32 characters cannot be stored in the field, because some of them required more than one byte for storage (for example, non-English characters).
When the field was defined as VARCHAR2(128 CHAR), in Oracle, there was enough space to store 32 characters. However, a single character may require up to 4 bytes.
Resolution
Perform the following local-change:
Change the field from VARCHAR2(128) to VARCHAR2(128 CHAR).
Published March 8, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.