SA-37817

Summary

A Text Area fields fails to commit the entered text sometimes upon submission a associated log error is seen.

Error Messages

'ORA-12899: value too large for column....'

Steps to Reproduce

Not Applicable

Root Cause

A defect or configuration issue in the operating environment.

The Oracle database system was using multi-byte character set (AL32UTF8) with NLS_LENGTH_SEMANTICS as BYTE.

​So a varchar2(255) column will hold 255 bytes.

In a multi-byte character set some characters (for example, a double quotation mark) would be represented in multiple bytes exceeding the limit of the varchar2 column and resulting the error.

Resolution

Perform the following local-change:

Change the NLS_LENGTH_SEMANTICS to CHAR.
Or,
Use the CHAR keyword when declaring a column length (for example: varchar2(255 CHAR) rather than varchar2(255), which would result in a column that holds 255 characters rather than 255 bytes):

https://pdn.pega.com/support-articles/curly-apostrophe-text-causes-commit-error
https://pdn.pega.com/make-your-applications-oracle-database-ready-internationalization