Question

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

Answer 1

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 So THAT Declared values ​​do not violate constraints.

Answer 2

This error is very common when some took a cycle counter by mistake and exceed the limit of the counter variable declared; what you need to do is declare the counter variable higher capacity and ready O also occurs in some character to number conversion and will convert string contains a character that is not a digit.

Answer 3

To cachar an error of this type only have to do is put any calculation of this type in a block BEGIN EXCEPTION END;