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!

25.3 Debugger Bug - Clears Input Parameters

Daniel Fox4 days ago

So I just updated to the new 25.3 update and hit a bug that is causing me to have to revert back to the 25.2.2 version.

Environment Versions

Version: 1.104.3 (user setup)
Commit: 385651c938df8a906869babee516bffd0ddb9829
Date: 2025-10-02T12:30:51.747Z
Electron: 37.3.1
ElectronBuildId: 12404162
Chromium: 138.0.7204.235
Node.js: 22.18.0
V8: 13.8.258.31-electron.0
OS: Windows_NT x64 10.0.26100

Extension Version 25.3

Scenario:

When inputting multiple variables into the Run/Debug screen, the input variables clear upon filling in the second one.

Steps to Reproduce:

  1. Open a packge that is compiled for debug or compile it for debug.
  2. Click Debug
  3. Double click on the first input parameter and fill it in, then click enter or tab
    1. Value is stored
  4. Double click on the second input paramter and fill it in, then click enter or tab. One of the following occurs (not always consistent)
    1. Value for Input parameter 1 and 2 are cleared
    2. Value for Input parameter 1 is cleared, and 2 sticks

Sample Code

create or replace PROCEDURE CURSOR_DBG_TEST ( 
P_INPUT IN VARCHAR2 
,P_INPUT2 IN VARCHAR2 
,P_DATE IN DATE 
,P_OUT_CUR OUT SYS_REFCURSOR 
) 
IS 
BEGIN 
DBMS_OUTPUT.PUT_LINE('P_DATE = ' || TO_CHAR(P_DATE, 'DD-MON-YYYY HH24:MI:SS')); 
DBMS_OUTPUT.PUT_LINE('P_INPUT = ' || P_INPUT || ' and P_INPUT2 = ' || P_INPUT2); 
OPEN P_OUT_CUR 
FOR 
SELECT * 
FROM SYS.ALL_TABLES 
WHERE OWNER = 'SYS' 
AND status = P_INPUT; 
END CURSOR_DBG_TEST;

Log Set the debug but unfortunately does not increment when the issue is occuring so I did not include it here.

Comments
Post Details
Added 4 days ago
3 comments
82 views