ORA-01438
value value greater than specified precision precision_scale for column column
- value: The numeric value being inserted or updated.
- precision_scale: The specified precision and scale for the column into which the value is being inserted or updated.
- column: The name of the column that the value was being inserted into or updated.
Cause
When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column. For example, for a column defined to be NUMBER(3,2), the precision or the maximum number of significant decimal digits is 3. The scale or the number of digits from the decimal point to the least significant digit is 2. In this case, a value of 123.89 will cause the error because the precision allows a maximum of 3 digits and 2 of them must be to the right of the decimal point. A value of 3.89 will not cause the error.
Action
Enter a value that complies with the precision defined for the numeric column. You can also use the MODIFY option with the ALTER TABLE command to redefine the precision.