6 Replies Latest reply: Apr 9, 2013 5:45 AM by 937682 RSS

    "completion insight" and "change case as you type" won't work for sql file

    937682
      Hi there,

      Just updated to 3.1 on my Mac Lion. It's very likely a bug since it used the work with 3.0.

      I have a "temp.sql" file where I store several queries. I start SQL Developer, open "temp.sql", connect to a DB but "completion insight" and "change case as you type" won't work anymore.

      If I click in "Unshared SQL Worksheet", the new worksheet tab will work fine with completion and change case, but I want to use my temp.sql and save things there when closing the application.

      To reproduce yourself the issue:

      Open SQL Dev, connect to a DB (it will open a worksheet), do some queries and check that change case and completion are working, quit SQL Dev, but save the worksheet in a sql file before. Re-open SQL Dev and open the sql file. Connect to the same DB and try to change the queries or create another. Completion and change case won't work anymore.

      About
      -----

      Oracle SQL Developer 3.1.07
      Version 3.1.07
      Build MAIN-07.42
      Copyright © 2005, 2011 Oracle. All Rights Reserved.
      IDE Version: 11.1.1.4.37.59.48
      Product ID: oracle.sqldeveloper
      Product Version: 11.2.0.07.42

      Version
      -------

      Component     Version
      =========     =======
      Java(TM) Platform     1.6.0_31
      Oracle IDE     3.1.07.42
      Versioning Support     3.1.07.42