AnsweredAssumed Answered

Oracle View - two columns remain empty in ArcMap (but not in SQL Developer)

Question asked by _robert_ on Jul 1, 2019
Latest reply on Jul 15, 2019 by _robert_

Hi there,

 

I have created a view in Oracle 11.2.. Its a view across three tables. I have contracts in one table  and people related to the contracts  in a second table (1:n). I need the people's names in a field next to the contract details (for export purposes only). Therefor I created a view using LISTAGG to concatenate all people's names related to a contract.

Works like a charm when viewed with SQL Developer. Unfortunately the column with the people’s names remains empty when viewed in ArcCatalog or opened in ArcMap. Its a table without any geometry. Any idea why just that single column remains empty? I casted the column type nvarchar2(500) - same data type and length as the column in the original table (which of course is displayed in ArcMap).

 

ArcMap 10.5.1, Win 10.

 

many thanks, Rob

Outcomes