In SQL Developer 17.2 on Windows 10 64bit, I can't view XMLTypes: they show up as null and an error is logged:
oracle.dbtools.raptor.controls.grid.ResultSetTableModel java.lang.ClassLoader.loadLibrary(ClassLoader.java:1867)
If I convert the connection to use the thin client, these values are shown as "(XML Type)" or XML, according to the preferences.
From the error it sounds as if there is a missing library, but I've not been able to get more details even with full logging enabled.
- Server: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- SQL Developer Version 17.2.0.188
- Full Instant Client 12.1.0.2.0 jdbcoci
- select xmlelement(foo) from dual