Decimals on Oracle

[boligoma]

Hi,

I'm having trouble in insert a decimal value from SQL 2005 to Oracle 10g. I'm using DS 7.5.1.A and ODBC as a connection.

The mistake is:
[DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-01722: invalid number

the field property are the same: decimal with lengh 8 and scale 2.

Using the real and the fix functions on the transformer stage it enters all the numeric (without decimal) values. In fix I'm using 2 on the scale value.

Any help would be appreciated,

 

[Turkbear]

Hi,
Have you checked the source data to be sure that each record has a valid number in that field?

You could add a constraint to the transform so that only records with valid numeric values in that field were sent to Oracle and others to an error file..









To Paraphrase:"The Help you get is proportional to the Help you give.."