Oracle FLOAT(126) Data Type Supported in SDE?

deleted-user-GpZRmORkzrlh — Sun, 21 Aug 2011 20:13:44 GMT

I have a spatial table where the lat,long and measurement fields are FLOAT(126) data type in Oracle. I cannot see the precision when viewing these field values in ArcMap but can see them in Oracle. For example, my measurement value is 9.19 in Oracle but only shows 9 in ArcMap. Are Oracle FLOAT(126) data types not supported in SDE?

Re: Oracle FLOAT(126) Data Type Supported in SDE?

JonDeRose — Mon, 22 Aug 2011 17:30:13 GMT

Hi Kelly,

FLOAT(126) is an Oracle DBMS-specific type and thus not technically supported within ArcGIS; however, you should still be able to view the values from within ArcMap/Catalog correctly as this field's values would be mapped as a Double "SE_FLOAT64_TYPE" with a precision of 38 by default.

I performed a quick test with ArcGIS/SDE 10 sp2 and Oracle 11.2.0.1 and found that my FLOAT field displays as a Double within ArcGIS as expected. Please confirm that if viewed within ArcCatalog, the values from this field display as expected (ie. 9.19)?

This may be a case of the field properties having been set to not display any decimal places. To check this please do the following:

1) Add the table to ArcMap
2) Right-click the table and open the attribute table
3) Right-click the field in question and choose properties
4) Within the Field Properties Dialog find the "Number Format" listing and click the ellipses (...)
5) Check the setting for rounding in the new Number Format dialog, increase the value from '0' to '2' if applicable.
6) Click OK, Apply and then view in ArcMap attribute table

Depending upon the application of this table and field you should not encounter any issues as a result of this table definition.

For further information please see the following web-help for additional information comparing ArcSDE/Oracle datatypes:

A comparison of ArcGIS, ArcSDE, and Oracle data types
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n00000067000000

topic Oracle FLOAT(126) Data Type Supported in SDE? in Data Management Questions

Oracle FLOAT(126) Data Type Supported in SDE?

Re: Oracle FLOAT(126) Data Type Supported in SDE?