How to Work Around "ORA-12899: value too large for column" when Polling a Database where the Primary Key Exceeds 100 Bytes
Last updated on JANUARY 04, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms