Page 1 of 1

APT_CombinedOperatorController,1: [DataDirect][ODBC Oracle W

Posted: Mon Feb 23, 2009 5:02 pm
by saidvs
Hi All,

I am using ODBC stage to load into oracle table. The datatype of one field is defined number and the datastage is reading it as decimal (38,10).
when I run the job am getting following error.

APT_CombinedOperatorController,1: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 3.

Any ideas how to overcome it. I am new to datastage so may be a simple question. I tried couple of option n didnt work for me.

Thanks,
Venkat

Posted: Mon Feb 23, 2009 9:10 pm
by gsym
first thing is disable operator Combinability to see the full log. is the column in Oracle is represented as just number or of type number(2,4) ?