laptop and a wrench

Bug

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, 2018 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000087604
SubmittedMay 12, 2015
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
Version Fixed1.4
StatusFixed

Workaround

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.

Steps to Reproduce

Bug ID: BUG-000087604

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options