Orace error: ORA-01438: a problem where the value is greater than the allowable precision specified by this column

Orace error: ORA-01438: a problem with a value greater than the allowable precision specified in this column when operating the Oracle database reported the following error: Java code www.2cto.com ORA-01438: if the value is greater than the value specified in this column, the length of the data type is incorrect. For example, if the value is defined as number (200.12) but is inserted, an error occurs. The reason is the number (p, s) problem. Number (p, s), where p indicates the total length of the number, and s indicates the decimal place. If s is a negative number, the number of digits is rounded up. For example, if number (4,-3), the storage value of the number 1234 is 1000; if number (4,-2), the storage value of the number 1234 is 1200. When setting the type of fields in the database table, note that NUMBER () Double has a decimal NUMBER (4) Long as an integer.