Oracle DB Error ORA-06502 PL/SQL: numeric or value error string

The following is the cause of this error message:

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 you can take to resolve this issue: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related