Important Announcement
This forum will be discontinued.
The creation of new topics is disabled.
Please open GitHub issues for the corresponding topics/products in the following Trivadis repositories:
- PL/SQL & SQL Coding Guidelines
- PL/SQL Cop Command Line
- PL/SQL Cop for SonarQube
- PL/SQL Cop for SQL Developer
- PL/SQL Cop Validators
- PL/SQL Analyzer
- PL/SQL Unwrapper
A lot of users have already a GitHub account and the management of the issues is better than in this forum. For example, closing a forum topic is never related to a product change. Closing a GitHub issue for an accepted bug means that the bug is fixed. This should simplify the work for all involved parties.
See this blog post for more information.
Thank you for your understanding.
Hello,
I am encountering following problem: after I perform a check with PL/SQL Cop for SQL Developer I can not use my code templates anymore. When I open Preferences -> Database -> SQL Editor Code Templates all the code templates are gone.
When I restart SQL Developer everything is ok again, but when I try to add a new template first the configuration is corrupt.
Is this a known issue ?
No, this is not known. I can reproduce it. I use some utPLSQL templates. I've done the following:
1) typed "ut", crtl-tab, selected a template
2) right click, selected "Check"
3) typed "ut", ctrl-tab, selected another template
So using them does not seem to be a problem. But when I open "Preferences" as you've mentioned, no code templates are shown. Looks like a bug. Strange.
As a workaround, never save code templates in the preferences after "Check". Restart SQL Developer before changing code templates. Then you shouldn't lose them (again). Not nice, I know, but at the moment I have no better idea.