My Oracle Support Banner

How to Resolve Error 'ORA-12899: value too large for column "{Schema Name}"."{Table Name}"."{Column Name}"' (Doc ID 2518885.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Commerce Platform - Version 11.2 and later
Information in this document applies to any platform.

Goal

Resolve database error 'ORA-12899: value too large for column "{Schema Name}"."{Table Name}"."{Column Name}"'.

For instance, following exception may be seen in the server log:

The STATE NAME column may be designed to store state name abbreviation, but users may enter the full state name if the UI allows users to do so.

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
Goal
Solution
 1. In the case of custom table column
 2. In the case of out of the box table column


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