ORA-06502: PL/SQL: numeric or value error

ORA-06502: PL/SQL: numeric or value error

Problem :

We come across this common exception when we are using PL/SQL or we receive soap related webservice response.

Exception I Encountered Was :

###################################################################################################################

ORA-06502: PL/SQL: numeric or value error

###################################################################################################################

Solution :

This exception was caused when i was trying to assign a value which was big enough for a input value. It started throwing these errors. It was also caused when trying to insert too many characters into a string field.

Make sure the input value you are giving for the web service are not violating the limit set by the web service.

Example :

- Validate the input fields against the web service fields and you should be able to resolve this issue.

Similar Exception :

     

- ORA-06502: PL/SQL: numeric or value error