Skip to Content
0
Former Member
Jul 06, 2007 at 08:20 AM

data type convert in UDC data extraction

36 Views

HI,All

One field (SUMVALUE) in Table A in oracle system is type NUMBER(9,4) , after connect by UDC when i create a datasource base on this table , it automatically regard type of this field as INT4, so when i loading the data,

error occurs:

'S:RSSDK:400 Cannot convert a value of '50.091' from type java. lang.String to INT at field SUMVALUE'

Anyone can suggest me how to deal with it?