ORA-01438：该列允许的值大于指定的精度

您要存储的数字对于该字段而言太大。看一下标度和精度。两者之间的区别是可以存储的小数点前的位数。

select cast (10 as number(1,2)) from dual * ERROR at line 1: ORA-01438: value larger than specified precision allowed for this column

select cast (15.33 as number(3,2)) from dual * ERROR at line 1: ORA-01438: value larger than specified precision allowed for this column 下端的任何内容都会被截断（无提示）

select cast (5.33333333 as number(3,2)) from dual; CAST(5.33333333ASNUMBER(3,2))

                     5.33