ORA-06502: PL/SQL: numeric or value error
Cause:
Error 1: 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
Error 2: 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.
Error 1: 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
Error 2: 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 comments: