Dragging in an Oracle database view to ArcMap 10.3 converts long integer fields created with default settings to double, and all values are converted to 0.
Last Published: October 4, 2018ArcSDE/Enterprise Geodatabase
Bug ID Number
May 12, 2015
January 28, 2021
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
Specify precision of 10 when creating the long integer fields.ORAdd the database view from File menu > Add Data.ORCreate the database view using the CAST function to specify the column precision to NUMBER(10).ORUse a double field instead of long.ORThe Table to Table tool can be used to create a new table that uses a double field. The data type can be changed in the Table to Table's Field Mapping window.