Does VS Code support debugging Stored Procs — oracle-tech

    Forum Stats

  • 3,715,829 Users
  • 2,242,890 Discussions
  • 7,845,628 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Does VS Code support debugging Stored Procs

4220285
4220285 Member Posts: 1

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

  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 1,786 Employee
    edited May 2020

    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.

Sign In or Register to comment.