- 3,715,956 Users
- 2,242,917 Discussions
- 7,845,700 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 475 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 5 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 417 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 9 DevOps
- 3K QA/Testing
- 256 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 67 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
Connection Issue with Oracle Tools for Visual Studio Code
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
Best Answers
-
I generated another script file, this time with the extension *.plsql. I've opened that file in a tab and hit F1. Selected 'Change Language' and selected Oracle SQL and PL/SQL. Ran the script, same error as before.
All that said, the Micorosft SQL extension is installed. Do we want to try uninstalling it and see what the differences are, or do you need some readings first? - jdb
-
I am not able to reproduce the issue in version 19.3.3. Thanks for the follow-up. - jdb
Answers
-
After you press F1, is it prompting you to change the language and are you changing it to "Oracle SQL and PL/SQL"? Down on the very bottom of VS Code do you see "Oracle SQL and PL/SQL" when the .SQL file is selected?
My concern is that the .SQL file is associated with some other extension like SQLTools or MSSQL.
One way to avoid this headache is to rename the file to .PLSQL.
-
I generated another script file, this time with the extension *.plsql. I've opened that file in a tab and hit F1. Selected 'Change Language' and selected Oracle SQL and PL/SQL. Ran the script, same error as before.
All that said, the Micorosft SQL extension is installed. Do we want to try uninstalling it and see what the differences are, or do you need some readings first? - jdb
-
Could you please try this out in the new 19.3.3 version and let me know if it is fixed for you?
-
I am not able to reproduce the issue in version 19.3.3. Thanks for the follow-up. - jdb