Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't view XML in Oracle SQL Developer 24.3.1 using InstantClient 23.6 OCI/Thick driver mode

James TaubergJan 24 2025

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!

This post has been answered by James Tauberg on Jan 24 2025
Jump to Answer
Comments
Post Details
Added on Jan 24 2025
1 comment
1,175 views