Skip to Main Content

SQL Developer 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!

Feature: enable DBMS_DEBUG

Peter HansAug 18 2025

Oracle SQL Developer allows both DBMS_DEBUG & DBMS_DEBUG_JDWP, being the second one a lot more dificult to setup on database side:

While DBMS_DEBUG requires no settings on database side. Please enable this mode for VScode.

When DBMS_DEBUG_JDWP is not configured an error like this ocurrs:

Connecting to the database DB.WORLD.
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.90.24.87', '50081' )
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1

https://docs.oracle.com/error-help/db/ora-24247/
Process exited.
Disconnecting from the database DB.WORLD.

This post has been answered by Daniel Fox on Aug 20 2025
Jump to Answer
Comments
Post Details
Added on Aug 18 2025
6 comments
114 views