Frequently asked question

Why does the SimpledataLoader and the ObjectLoader map RDBMS integer fields to doubles?

Last Published: April 25, 2020


When you export long integers from Oracle they are mapped to a double to avoid overflow. Oracle does not have a true long integer type, using a number(10), which can contain numbers larger than will fit into a long. This also is a problem with short integers, which map to a long integer on export.

Currently the ObjectLoader UI does not allow the mapping of larger fields to smaller fields. This could be changed, but at the risk of having some imports failing in the middle of the load when a field is too wide.

The workaround is to use double rather than long integer when you plan on constantly importing and exporting data into the same template.

Article ID:000005494

  • ArcMap 9 x
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic