PLS-01907: : number precision too large

PLS-01907: : number precision too large
Cause: The number begin copied or assigned had too many digits to the left of the decimal and did not fit into its destination. In other words, there is a number precision mismatch. This error may also occur if, for example, an attempt is made to assign a character string to a number, as demonstrated below. a varchar2(4); b number(1,1); a := '10.1'; b := a;
Action: First, check explicit number precision value mismatches. If none are found, then consider implicit conversions of other types to numbers, including conversions performed during binds.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:03

PLS-01907：：数字精度太大,
.原因：开始复制或分配的数字在十进制左侧的数字太多，不符合其目的地。换句话说，存在数字精度不匹配。如果例如尝试将字符串分配给一个数字，也可能会发生此错误，如下所示。varchar2（4）; b号（1,1）; a：= '10 .1'; b：= a,
.操作：首先，检查显式数字精度值不匹配。如果没有找到，则考虑其他类型的隐式转换为数字，包括绑定期间执行的转换。,
.

aiaiDBA

13718043309

010-86462881

PLS-01907: : number precision too large

1 个回答

相似问题