topic ORA-01426:numeric overflow in Data Management Questions https://community.esri.com/t5/data-management-questions/ora-01426-numeric-overflow/m-p/681217#M38625 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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:</SPAN><BR /><BR /><STRONG>database row change an unexpected failure occurred. Underlying DBMS error[ORA-01426:numeric overflow]</STRONG><BR /><BR /><SPAN>our environment:</SPAN><BR /><BR /><SPAN>ArcSDE 10 SP3</SPAN><BR /><SPAN>Database Oracle 11gR2 (11.2.0.1)</SPAN><BR /><SPAN>ArcGIS Desktop 10 SP3</SPAN></BODY></HTML> Sun, 09 Dec 2012 02:05:45 GMT EmadAl-Mousa 2012-12-09T02:05:45Z ORA-01426:numeric overflow https://community.esri.com/t5/data-management-questions/ora-01426-numeric-overflow/m-p/681217#M38625 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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:</SPAN><BR /><BR /><STRONG>database row change an unexpected failure occurred. Underlying DBMS error[ORA-01426:numeric overflow]</STRONG><BR /><BR /><SPAN>our environment:</SPAN><BR /><BR /><SPAN>ArcSDE 10 SP3</SPAN><BR /><SPAN>Database Oracle 11gR2 (11.2.0.1)</SPAN><BR /><SPAN>ArcGIS Desktop 10 SP3</SPAN></BODY></HTML> Sun, 09 Dec 2012 02:05:45 GMT https://community.esri.com/t5/data-management-questions/ora-01426-numeric-overflow/m-p/681217#M38625 EmadAl-Mousa 2012-12-09T02:05:45Z Re: ORA-01426:numeric overflow https://community.esri.com/t5/data-management-questions/ora-01426-numeric-overflow/m-p/681218#M38626 <HTML><HEAD></HEAD><BODY><SPAN>Every time I've gotten a "numeric overflow" error, it was because I generated a numeric overflow.</SPAN><BR /><BR /><SPAN>Look for a NUMBER(5) column with a value greater than 99999.&nbsp; You should also make sure the</SPAN><BR /><SPAN>business table and adds table have the same type definitions.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sun, 09 Dec 2012 10:36:18 GMT https://community.esri.com/t5/data-management-questions/ora-01426-numeric-overflow/m-p/681218#M38626 VinceAngelo 2012-12-09T10:36:18Z