Oracle Error: ORA-06502
Error Description:
PL/SQL: numeric or value error
Error Cause:
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:
SQL> DECLARE
2 i NUMBER;
3 BEGIN
4 i := ' ';
5 END;
6 /
DECLARE
*
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.
Action:
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
|
|
|
