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:
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?