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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,431 views

1 mention