Oracle Error: ORA-06502
PL/SQL: numeric or value error
A statement was executed that resulted in an arithmetic, numeric, string, conversion, or constraint error. This error mainly results from programmer error or invalid data input. For example:
2 i NUMBER;
4 i := ' ';
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 4
This error may also occur 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 999 to a variable declared NUMBER(3), or if an attempt is made to assign more than 5 characters to a VARCHAR2(5) variable.
Change the data, how it is manipulated, or how it is declared so that values do not violate the declared data type definitions.
|There haven't been any comments added for this error yet. You may add one if you like.
Add a comment