I have a fresh install of Windows 64-bit SQL Developer 24.3.1.347 and InstantClient 23.6. If I connect without the OCI/Thick client, when I query a table with an XMLType field, I see (XMLType) in the grid. I can double click it to open a window that shows the XML. If I try to use the OCI/Thick Client to do a RADIUS connection (Preferences>Database>Advanced and setting up the Thick client and checking the box (with a tested working driver)), that xml viewing functionality goes away. When I query the same table using the OCI/Thick client, the XMLType field shows (null) in the grid which is NOT true, the field contains xml that can't be seen. In the logs, I see the following error: Source: oracle.dbtools.raptor.oviewer.base.ViewerAddin$XMLParser Message: Could not Load :oracle.dbtools.raptor.plsql.PLSQLCodeViewer cannot be found by oracle.sqldeveloper_24.3.1
If I trun off the OCI/Thick client and restart the functionality returns. I also can't seem to make the RADIUS connection with TCPS and was forced to add: SQLNET.RADIUS_ALLOW_WEAK_PROTOCOL = TRUE to my sqlnet.ora file to even allow it to connect. Note that the db with the XMLType column is in a dev db that does NOT require RADIUS, but other connections I make do require it.
As stated, I tried to turn on and off the OCI/THICK Client which affects the problem as described.
I think this is either a bug with integration between SQL Developer 243.1.347 and Instant Client 23.6 or possibly a misconfiguration on my part? I do have a workaround I will post next.
If it's a bug, I hope someone will fix it. Thank you!