We have Oracle 11g View tables set up. View Fields cast as DOUBLE PRECISION return 0 values when viewed in ArcGIS 10x desktop (ArcMAP; ArcCATALOG). ArcGIS shows these fields as being Long Integer. DECIMAL, VARCHAR fields do not present the same issues and read ok in ArcGIS. This problem is specific to ArcGIS 10x as ArcGIS 9x did not have these problems. Anyone know the answer? Thanks very much.
What do DESCRIBE in SQL*PLUS and 'sdetable -o describe' report? If your DOUBLE PRECISION is defined as "38,0", then that will map to SE_INTEGER_TYPE, while (37,0) or (38,1) will map to SE_FLOAT64_TYPE.