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