This issue falls under the Visual Studio Code extensions for Oracle, version 19.3.1: I am connected to a database server in the Data Explorer. I open a .SQL file in another tab, and I hit F1 to connect, going through the steps to select the connection used previously. I select the same connection the Database Explorer window is using, which was created from a TNS entry. So far, so good. I hit Ctrl+R to run the entire script and I get an immediate fail with this error message...
Error: Specified URI '{0}' does not have existing connection
Error: Script execution Cancelled
I can go back to the Explorer Window, and it's still working. I verified that by right-clicking on a table and selecting 'Show data'.
Let's say that I think the extension ran into a problem with the max number of open sessions set for the DB schema owner. Or some other theory. Is there a log file, etc, I can check for details? - jdb