topic ArcGIS Pro 2.4.2 | in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-2-4-2/m-p/162016#M7347 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>With Oracle views, I am trying to create Query Layer. Once I selected the unique identifier, the table shows in Contents but right-click to open the table gives an "ORA-01455: converting column overflows integer datatype error"</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/476610_pastedImage_2.png" /></P><P></P><P>Apparently, it is a well-known limitation of Oracle field NUMBER(38) mapping to ESRI Long but with 10 digits only:</P><P><A class="link-titled" href="https://support.esri.com/en/technical-article/000010398" title="https://support.esri.com/en/technical-article/000010398">FAQ: Does ArcSDE support ObjectID field as 64-bit integers in Oracle?</A>&nbsp;</P><P></P><P>My unique identifier are 12 digits long. How can I open Query Layer tables with such unique identifier? If the problem is known, there must be a solution.</P><P></P><P>Would converting unique identifier column in Oracle to text a good solution?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 19 Dec 2019 14:28:05 GMT VincentLaunstorfer 2019-12-19T14:28:05Z ArcGIS Pro 2.4.2 | https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-2-4-2/m-p/162016#M7347 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>With Oracle views, I am trying to create Query Layer. Once I selected the unique identifier, the table shows in Contents but right-click to open the table gives an "ORA-01455: converting column overflows integer datatype error"</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/476610_pastedImage_2.png" /></P><P></P><P>Apparently, it is a well-known limitation of Oracle field NUMBER(38) mapping to ESRI Long but with 10 digits only:</P><P><A class="link-titled" href="https://support.esri.com/en/technical-article/000010398" title="https://support.esri.com/en/technical-article/000010398">FAQ: Does ArcSDE support ObjectID field as 64-bit integers in Oracle?</A>&nbsp;</P><P></P><P>My unique identifier are 12 digits long. How can I open Query Layer tables with such unique identifier? If the problem is known, there must be a solution.</P><P></P><P>Would converting unique identifier column in Oracle to text a good solution?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 19 Dec 2019 14:28:05 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-2-4-2/m-p/162016#M7347 VincentLaunstorfer 2019-12-19T14:28:05Z