Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I open text files with VS Code and execute them against an Oracle database?

User_WF38YJun 30 2021

I have installed Oracle Developer Tools for VS Code and connected Oracle Explorer to my database.
I want to open code files with various file extension and execute the SQL or PL/SQL in them on the Oracle database.
I have added these file associations to VS Code so VS Code is recognizing the files:
User:
I open a pck file (File/Open)
and hit run Run without Debugging and get
User:

How can I execute it?
I am using
Version: 1.57.1 (Universal)
Commit: 507ce72a4466fbb27b715c3722558bb15afa9f48
Date: 2021-06-17T13:28:32.912Z (1 wk ago)
Electron: 12.0.7
Chrome: 89.0.4389.128
Node.js: 14.16.0
V8: 8.9.255.25-electron.0
OS: Darwin x64 20.4.0

Oracle Developer Tools for VS Code 19.3.4
Thank you,
Andrew Bloss

Added on Jun 30 2021

#oracle-developer-tools-for-vs-code

10 comments

1,518 views

1 mention