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!

Bug: Populating date not saving when Running PL/SQL

Daniel Fox28 hours ago

VS Code / Extension Versions

Version: 1.103.2 (user setup)
Commit: 6f17636121051a53c88d3e605c491d22af2ba755
Date: 2025-08-20T16:45:34.255Z
Electron: 37.2.3
ElectronBuildId: 12035395
Chromium: 138.0.7204.100
Node.js: 22.17.0
V8: 13.8.500258-electron.0
OS: Windows_NT x64 10.0.26100

Extension Version: 25.2.2

Steps to Re-Produce:

Any code can do but this is the empty shell I verified the bug with for sharing

CREATE OR REPLACE PROCEDURE CURSOR_DBG_TEST ( 
	 P_INPUT 	IN 		VARCHAR2 
	,P_OUT_CUR 		OUT SYS_REFCURSOR 
	,P_DATE 	IN 		DATE
) 
IS 
BEGIN 
	DBMS_OUTPUT.PUT_LINE('P_DATE = ' || TO_CHAR(P_DATE, 'DD-MON-YYYY HH24:MI:SS')); 
	OPEN P_OUT_CUR 
	FOR 
		SELECT * 
		FROM SYS.ALL_TABLES 
		WHERE OWNER = 'SYS' 
		AND status = P_INPUT; 
END CURSOR_DBG_TEST;
  1. Pick your package/procedure to run.
  2. Choose either Run or Debug (issue happens with both modes as its UI)
  3. There are 3 different ways I've had this happen
    1. Click the edit button on the date parameter field and click “Save” w/o changing the date populated.
    2. Click the edit button on the date parameter field and change the date before clicking “Save”
    3. Click in the field in the Input value and click enter w/o changing the value
  4. Upon clicking enter or save, the input parameter is reverted to (null).

The only way I can get the date to stick is to either create a wrapper procedure to call this manually (messy), or to click in the field inline, edit the value and click the enter key. Then the date sticks.

Additional Bug-like observations:

  1. If a date is populated, I cannot wipe the date out back to (null)

  2. the date value in the input value field does not follow the extension NLS Settings

    1. Value in .run screen: (it uses the format dd/mm/yyyy hh:mi:ss AM)

    2. Configured NLS Settings

  3. The Date in the .run screen uses the format dd/mm/yyyy hh:mi:ss AM however does not display the AM/PM portion to the screen.

    1. I tried typing the time 20:00:00 and it reverted to 08:00:00
    2. I tried typing the time 00:00:00 and it reverted to 12:00:00

If there are logs that are helpful let me know what to grab. I did not see the log on Info or Debug mode change when using the date picker so I did not include them here.

Comments
Post Details
Added 28 hours ago
1 comment
27 views