I am trying to get debug of PL/SQL working with Visual Studio Code and the Oracle SQLDeveloper extension.
To keep it simple, I have a single user with single stored procedure that I want to debug.
I have created the database ACL, added connect and resolve privileges, and assigned to my client static LAN IP address in a range known to VS Code settings.
There are no firewall rule issues. I have disabled the firewall on both the database server and my client machine for testing purposes.
Compiling my stored procedure for debug is successful.
Here is where my issue is:
When I try the Run or Debug button (and choose either) nothing happens. I am expecting a form to prompt me to generate the debug stub and offer me the Debug button.
My user has been granted connect and resource roles as well as the debug connect session privilege.
VS Code is Version: 1.99.1 (latest as of now) SQL Developer Extension 25.1.0 (latest as of now) My client is MacOS Sequoia 15.3.2 (latest as of now) Oracle Database is EE 19.21 (this should not be relevant to the issue)
Updated (in response to Jeff's comment):
- added screenshot above of what functionality has no behavior
- code I am using is the code you provided in your comment example - https://www.thatjeffsmith.com/archive/2024/10/pl-sql-debugger-now-available-in-sql-developer-for-vs-code/ (i.e., array_job, debugging_step_into, debugging_debugger)
- database is 19c
DBMS_NETWORK_ACL:
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (acl => 'debug_permissions.xml', -- or any other name
description => 'DEBUG Access',
principal => 'HR', -- the database user name trying to access the network resource
is_grant => TRUE,
privilege => 'connect',
start_date => NULL,
end_date => NULL);
END;
/
COMMIT;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (acl => 'debug_permissions.xml',
principal => 'HR',
is_grant => TRUE,
PRIVILEGE => 'connect');
END;
/
COMMIT;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (acl => 'debug_permissions.xml',
principal => 'HR',
is_grant => TRUE,
privilege => 'resolve');
END;
/
COMMIT;
BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (acl => 'debug_permissions.xml',
HOST => '192.168.50.214', /*can be computer name or IP , wildcards are accepted as well for example - '*.us.oracle.com'*/
lower_port => 4000,
upper_port => 4999);
END;
/
commit;
grant debug connect session to hr;
