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!

Code Templates does not work in worksheets opened by drag&drop of files

3122561Aug 18 2023

When I try to use Code Templates I notice that it does not work in certain worksheets. I can have two worksheets side by side in the same Sql Developer session, but Code Templates work only in one of them. It makes no difference whether I use automatic code completion or I try to invoce the template manually (using ctrl+spacebar).
The content in the worksheet does not seem to affect the result. Once a worksheet desides not to allow Code Templates, it makes no difference if I erase all content in the worksheet. If I copy the content of a worksheet where Code Templates does not work, overt to a worksheet where it works, Code Templates still works fine.
It makes no difference whether the worksheet have been saved to a file or not.

After some limited testing, it seems to happen only with worksheets opened by drag&drop (in my case using Windows File Explorer). If I drag&drop a file to an open worksheet (which opens a new worksheet automatically), I cannot use Code Templates. If I open the same file using File>Open, there is no isssue.

I use Sql Developer version 22.2.1.234, build 234.1810.

Does anyone know how to fix this?

Comments
Post Details
Added on Aug 18 2023
1 comment
291 views