Can you please provide the part of the PL/SQL Code that is giving the error at the time of conversion from DB2 to Oracle. In general the "numeric or value error is given" when there is a data type mismatch.

Please check the code that is responsible for extraction of the data from DB2 database. Somehow I feel its returning a numeric value.

Regards
Shan