Please be sure you have downloaded and are running 23.1.1.345. We previously published SQL Developer version 23.1.1, with two mistakes:

  1. incorrect bundled java for windows/mac (11.0.18 vs 11.0.21)
  2. missing CLOB bug fix

As of TODAY, the 15th of December, 2023, we have the proper download archives available for you to download.

So, if you’re not seeing the proper behavior, make sure you have the 23.1.1 released on or after today, with build version 345.2114 following the 23.1.1.

Onto the details…

This is a maintenance release, bug fixes only.

Notable bug fixes

35420237 UI DEADLOCK ON COMPILING PLSQL FILE

Working with PL/SQL, and all of a sudden your application becomes unresponsive? Yeah, that should be fixed now.

35338513 TEMPORARY CLOBS ARE TRUNCATED WHEN EXECUTING STATEMENTS

Only getting first few dozen characters of text vs the entire CLOB, not good.

Java Update

The embedded Java Home is now

Java(TM) Platform11.0.21.0.2

35346394 FAILED TO SELECT MULTIPLE FIELDS IN COMPLETION-INSIGHT POPUP

Click through as many cols as you want…

35331754 SQLDEVELOPER DBA INSTANCE VIEWER MEMORY/STORAGE TAB IS NOT SHOWING DATA DETAILS

How and what is my database doing? View > DBA > Instance Viewer

What about the new-new stuff?

Unfortunately we ran out of days in 2023. We have our VS Code Extension all ready to go, just waiting for final licensing and legal sign-offs, so we can kick off 2024 with a bang! Stay tuned!

My last tease of 2023…believe me, I wish it were out as well!
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

16 Comments

  1. Not to ruin the surprise, but a rough timeframe for the VSCode version?

  2. In older versions (I am using 21.4.3) completion insight found table names in other schemas, so I don’t need to type the schema name. It looks like newer versions are just searching the current schema. Would you consider bringing back this functionality, or at least add an option for it in preferences? Thanks

    • I can log an ER for you, but we have no plans at this time to revert to the old behavior…which caused more problems than it solved.

  3. I still see some errors on connections that are defined using an ssh connection type. When opening such a connection, I get a java.lang.NoClassDefFoundError: org/apache/sshd/common/future/CancelOption
    Benny

    • Brian Dawley

      We are experiencing the same. Sent X post about it.

    • I encountered the same problem. You need to download the previous version (April 2023), then it works fine.

    • We’ve identified the problem and will have an update after the New Year, Merry Christmas 🎄🎁

    • …”We’ve identified the problem and will have an update after the New Year”

      It is now March 12 and the latest version is still the one from December containing that exact error.

    • Yeah it’s taking longer than we wanted, all I can offer is an apology.

      In the meantime use an older version as a workaround.

    • Any update for the java.lang.NoClassDefFoundError: org/apache/sshd/common/future/CancelOption issue?

    • scratch that. Restarted sql developer and snippets are back.
      Knut

Write A Comment