SQL Developer v17.2 is now Available.

thatjeffsmith SQL Developer 35 Comments

Tell Others About This Story:

Time to download!

Mostly bug fixes.

  • the frequent ‘connection reset’ message should be GONE
  • entering text data in a data grid cell and the cursor doesn’t advance should be FIXED
  • having a @ or a ; in a comment in your query should work AGAIN
  • many, many more bug fixes – see the release notes for details

Should work for F9 and F5

  • SQLcl updated, more bug fixes
  • ORDS 3.0.10 is included, even more bug fixes + Auto PLSQL feature

Brand New Features

You can search your RESTful Service handler code now using the Database Search panel! View > Find DB Object. Expand Code section. Check ‘ORDS’ – this will search everything in the ORDS Handler P_SOURCE area.

ORDS integration is one of my favorite new features in SQLDev.

Speaking of ORDS, you can now quickly export your ORDS RESTful Service definitions to the clipboard, worksheet, or a file.

Just a ‘touch’ feature, but very handy.

DBA Toys

We have two new items in the DBA panel. We have FX viewers and reports for Data Guard and Sharding.

A very simple setup, but you get the idea.

And, if you right-click you can get into the DG info for the Standby west.dbs2 setup.


You don’t have to be running a Sharded 12c database to get the Data Guard support.

Remember When I Told You We Were Changing Up Our Release Schedules/Process?

No? Read this. 

So in about 3 months, we’ll have a 17.3 update. Again, mostly bug fixes, but maybe a few toys as well.


Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 35

  1. Hey, Jeff!
    One thing I can not understand, why is it 17.2? There were versions 1.1, 2.1, 3.0, 4.0, 4.1, 4.2 and then… 17.2! Did I miss something? Where did 5.0, 6.2, 12.3, etc. go? Which one going to be the next one, 189.73?
    I know it’s kind of stupid question, but I’m just trying to understand what’s going on with this world.

    1. thatjeffsmith Post
  2. Good morning please , I’ve dificult to create new connection with Sqldeveloper version 17.2 ,
    can you help me?

    1. thatjeffsmith Post
  3. Jeff,

    Great to see quarterly updates to a great tool.

    I ran into an issue on 17.2 that most would not have. I had created custom actions in 4.1.5 & 4.2.x on SCHEDULER->Jobs. These migrated as I have updated version

    Now on 17.2 when bringing up the context menu, right-click, Nothing happened. I dropped my custom action and restarted SQL Developer. The now work as expected. The fact that my custom code failed is not a SQLDEV issue, Not giving a better error my code was broken, maybe.

    BTW the most important part of my code was running jobs is no longer needed. Thanks

    1. thatjeffsmith Post
  4. Code outline still shows a red dot (and no outline) for some large packages.

    community . oracle . com / thread / 4053955

    I’m staying on 4.1.5 for the time being.

  5. Hi Jeff,

    Any way we can enable DG in DBA panel without DG broker enabled? Our client current setup doesn’t uses the DG broker in 11g due to the need to use SYS password , and in our case sys password is not being used to due to security concerns, please advise 🙂

    1. thatjeffsmith Post
  6. While connecting to a database where DG is configured and logging in with SYS user, still unable to see DG icon under View > DBA…

    1. thatjeffsmith Post
        1. thatjeffsmith Post
          1. thatjeffsmith Post
    1. thatjeffsmith Post
  7. I noticed 17.2 also fixes a small issue I was having on Windows 10. On previous versions (4.1, 4.2) when I pinned SQL Developer to the task bar and then opened it I would get 2 SQL developer Icons on the task bar.

    In 17.2 I just get 1. I guess this could also be from the updated JAVA version it ships with.

    And no “Your connection has been reset” messages so far.

    Nice – I Like it!

    1. thatjeffsmith Post
  8. Windows Defender SmartScreen won’t allow sqldeveloper.exe to execute.

    Running Windows 10 with administrator privileges, I unzipped the files to a directory and double-clicked the .EXE. Defender immediately displays a dialog stating “Windows Defender SmartScreen prevented an unrecognized app from starting. Running this app might put your PC at risk.” Clicked on the “More Info” link to display the “Run anyway” button, then clicked it.

    Windows then displays a dialog “Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item”.

    After clicking “Ok” (the only button available), sqldeveloper.exe is removed from the SQL*Developer directory.

    Any ideas? I’m a Linux/Unix guy, not a Windows person.

    1. thatjeffsmith Post

      Nope, we didn’t change anything with the EXE.

      >>Windows then displays a dialog “Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item”.
      Where did you extract SQLDev to?

      1. I extracted to C:\Oracle\SQLDeveloper 17.2, which is a sibling directory to the 4.1 and 4.2 installs that work for me.

          1. thatjeffsmith Post
  9. I have downloaded sqlcl but version showed by running executable is not exactly the same:

    SQL> show version
    Oracle SQL Developer, comandos (SQLcl) versión:

    Is this a simple mistake in the version showed?

  10. Hi,

    The bug while printing a ref_cursor, with linesize set to max and sqlformat to ansiconsole remains!

    var rc1 refcursor;


    open :rc1 for
    select * from TABLE;


    print rc1;

    1. thatjeffsmith Post
    2. thatjeffsmith Post
        1. thatjeffsmith Post

          No, what I’m saying is, it’s not a bug without a bug ID from My Oracle Support or if you have a reference/test case on the forums and someone on our team has told you it’s a bug.

Leave a Reply

Your email address will not be published. Required fields are marked *