- 3,715,829 Users
- 2,242,890 Discussions
- 7,845,628 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 472 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
- 254 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 66 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
Does VS Code support debugging Stored Procs
I am using the Oracle Developer Tools extension for VS Code (not Visual Studio proper).
But I have not seen a way to debug into a stored procedure.
Two questions:
1. Does supporting remote stepping and debugging into a PL/SQL sproc (or a Java-authored one, but I am mainly interested in PL/SQL sprocs atm) mean it has to support it via JPDA?
2. Does this JPDA support exist, or is there an extension other than this one that is known to support remote PL/SQL sproc debugging from inside VS Code?
Answers
-
1) Yes. In our Visual Studio plugin we use JDWP. Currently we have not implemented this yet for VS Code.
2) I thought I saw a third party extension that implemented this, but I don't recall the name and I never tried it.
Another free option besides our Visual Studio extension is SQL Developer.