laptop and a wrench


Query layers fail to recognize the SQL Server REAL datatype or Oracle INTEGER/NUMBER(38) data type from ArcGIS 10.3.1.

Last Published: November 7, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000091447
SubmittedOctober 15, 2015
Last ModifiedOctober 20, 2021
Applies toArcSDE/Enterprise Geodatabase
Version found10.3.1
Operating SystemWindows
StatusWill Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.


In the query layer, CAST the 'real' datatype as 'float' or 'int'.Example:SELECT Link_Id, CAST (Hectares as float) as Hectares from dbo.Link_Table

Steps to Reproduce

Bug ID: BUG-000091447


  • 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