My Oracle Support Banner

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 AUGUST 17, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

The following error occurs when polling a database where the primary key exceeds 100 bytes:



According to <note 1113215.1>, the solution is:

 

  1. Delete the database adapter and recreate it selecting fewer columns when presented with the Attribute Filtering, or
  2. 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.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.