Hi,
I'm using
VS Code version 1.105.1
Oracle SQL Dev extension version 25.3.0
Windows 11 Prod 24H2
a relatively new PC - Intel(R) Core(TM) Ultra 7 268V (2.20 GHz)
First off - I really LOVE the extension (most of the times :) The ability to use GitHub Copilot is something I'm experimenting with, which wouldn't be possible without!
However, I have been running into issues as of late. I have packages containing many functions, often 5000+ lines.
The problem seems to be while editing, I might type a syntax error. If the “language server” or whatever you call it finds that, the “compile” icon is suddenly grayed out - along with all the other icons in that toolbar (compile for debug, run debug, open spec, etc). This in itself isn't a huge problem, except that once I fix the syntax error, it can takes sometimes MINUTES for the language server and VS Code to realize the error is fixed, continue scanning through the rest of the code, and then see it is free of syntax errors, before it will LET me compile again.
Since I'm on a relatively new computer, I wouldn't expect the syntax checking to take that long. Maybe (shrug) there is contention with other processes, like virus scanner and whatnot, looking at the traffic between processes slowing it down.
Either way, would it be possible to allow compiling even when the syntax is wrong? I understand I might get an error, but most times I've fixed it, and compiling again will tell me about any errors found anyways. If there's an option to turn the language server / syntax checking OFF - while still having all the other syntax highlighting and auto-completion working, that would work as well.
When I get tired of waiting, I have to entirely close VS code and launch everything again. When I'm writing a lot of code, this can happen often, causing a real lack of productivity. I did switch back to Java SQL Dev for a bit, but it's not a replacement for auto complete!
Thank you for any help :)
Regards,
Doug