ArcGIS 10 cannot read Oracle 11g DOUBLE PRECISION fields

432
1
03-27-2012 04:43 AM
Highlighted
New Contributor III
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.
Reply
0 Kudos
1 Reply
Highlighted
by Anonymous User
Not applicable
Original User: vangelo

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.

- V
Reply
0 Kudos