ORA-06502: PL/SQL: numeric or value errorstring

ORA-06502: PL/SQL: numeric or value errorstring
Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06502：PL / SQL：数字或值错误字符串,
.原因：发生了算术，数字，字符串，转换或约束错误。例如，如果尝试将值NULL分配给声明为NOT NULL的变量，或者尝试将大于99的整数分配给声明为NUMBER（2）的变量，则会发生此错误。,
.操作：更改数据，如何处理数据或如何声明数据，以使值不违反约束。,
.

aiaiDBA

13718043309

010-86462881

ORA-06502: PL/SQL: numeric or value errorstring

1 个回答

相似问题