This discussion is archived
6 Replies Latest reply: Apr 9, 2013 3:45 AM by 937682 RSS

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

937682 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points