Skip to Main Content
Forums

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!

Does VS Code support debugging Stored Procs

4220285May 16 2020 — edited May 17 2020

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?

Comments

Christian.Shay -Oracle

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.

Hi, we have added support or PL/SQL debugging in version 21.4.0. Please try it out and let me know what you think!

1 - 2

Post Details

Added on May 16 2020
#oracle-developer-tools-for-vs-code
2 comments
673 views