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 ModifiedJanuary 28, 2021
SeverityMedium
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 help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback