I want to use another VsCode extension which maps the file association to ( .sql )
I also want it to work with plsql source code files.
In my settings.json I change the
"files.associations": {
"*.sql": "sql",
"*.pks": "sql",
"*.pkb": "sql",
"*.pls": "sql",
}
Doing this, enables the other extension to consume these file types and provides the desired behaviors.
Remapping ( .pls, .pks, .pkb ) prevents SQLDEV from displaying its icons in upper right corner (Run, Compile, Debug, etc).
As a workaround, I can use keyboard mappings with SQLDEV as a substitute for the icons. This works! Key mappings F5, F7, F9, and more.
But one unexpected side effect is object tree breakage. Package spec, procedures, functions, triggers, types CAN be opened, but packages cannot be +Expanded, so cannot open package bodies in a worksheet.
If the package body expansion can be fixed, it seems this key mapping workaround would permit SQLDEV to be used in conjunction with other extension(s).
Fixing this matter would be much appreciated. What do you think about this?