ORA-01426:numeric overflow

[EmadAl-Mousa]

Hi,

we have a versioned feature class in our production system, whenever we try to edit a field in it using ArcMap we are receiving the following message:

database row change an unexpected failure occurred. Underlying DBMS error[ORA-01426:numeric overflow]

our environment:

ArcSDE 10 SP3
Database Oracle 11gR2 (11.2.0.1)
ArcGIS Desktop 10 SP3

[VinceAngelo]

Every time I've gotten a "numeric overflow" error, it was because I generated a numeric overflow.

Look for a NUMBER(5) column with a value greater than 99999.  You should also make sure the
business table and adds table have the same type definitions.

- V