ArcGIS Pro 2.4.2 |

12-19-2019 06:28 AM
Occasional Contributor III


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"

Apparently, it is a well-known limitation of Oracle field NUMBER(38) mapping to ESRI Long but with 10 digits only:

FAQ: Does ArcSDE support ObjectID field as 64-bit integers in Oracle? 

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.

Would converting unique identifier column in Oracle to text a good solution?


0 Kudos
0 Replies