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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Answer

Yes. Async, semi-sync, and InnoDB Cluster.

Marked as Answer by 3602098 · Sep 27 2020
Basharat Hussain Oct 16 2024

Dear @dave-stokes-mysql-community-team-oracle

I am facing a problem please Guide me.

I have deployed two MySQL Nodes version 8. I am trying to async MySQL nodes, the replication complete successful as long as a user create or some action performed from the application. When an action is perform from the Application . On the slave node the following error occur.

Before an action perform from the Application everything working fine replication from master to slave working as expected.

Please Guide me.

Thank You in Advance.
Basharat Hussain.

L. Fernigrini Oct 16 2024

You are replying to a 5 year old “solved” thread with a new problem…Please do not hijack existing threads, open a new one with the appropriate details. I'm closing this one.

1 - 3

Post Details

Added on Jan 24 2025
1 comment
171 views