Invalid Number

pradkumar · Post by **pradkumar** » Thu Dec 07, 2006 7:19 pm

Hi

I am trying to read data from oracle and laod the data again to a table in oracle.
I am getting invalid number error. i checked the datatypes and loaded one by one. i found that one of my field "REP_ID" is causing invalid number error.
In the source it is of varchar datatype and nullable.
In the target it was decimal, but now I changed it to varchar and still it gives the same error.

REP_ID:
YAU102388
YSG-1
2390

I am unable to get what might be the problem

narasimha · Post by **narasimha** » Thu Dec 07, 2006 7:30 pm

Check all the places you have reference to this field

- In your job.
- In the databasse where you have made change to the column data type

ray.wurlod · Post by **ray.wurlod** » Thu Dec 07, 2006 7:37 pm

Changing it in the DataStage job is not enough. If the target table still has it defined as a numeric data type, it still won't work with the alphabetic characters in it.

pradkumar · Post by **pradkumar** » Thu Dec 07, 2006 7:57 pm

Thx..

I changed in the target also now. Its working