ORA-12899: value too large for column
ORA-12899 occurs while deploying a JAR file.
A Problem occurred during import: ORA-12899: value too large for column "CLAWS_PEGA_RULES"."PR_INDEX_REFERENCE"."PXRULEFAMILYNAME"
Steps to Reproduce
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.
Perform the following local-change:
Change the field from VARCHAR2(128) to VARCHAR2(128 CHAR).
0% found this useful