How to Work Around "ORA-12899: value too large for column" when Polling a Database where the Primary Key Exceeds 100 Bytes
(Doc ID 1454595.1)
Last updated on NOVEMBER 19, 2019
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
The following error occurs when polling a database where the primary key exceeds 100 bytes:
According to <note 1113215.1>, the solution is:
- Delete the database adapter and recreate it selecting fewer columns when presented with the Attribute Filtering, or
- Manually edit or-mappings.xml and remove from the the elements corresponding to columns that are not necessary to ensure uniqueness.
This note provides an alternative workaround to the above solution.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document