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: Debug Output - Booleans not returned

Daniel Fox2 days ago

System/Extension information:

Version: 1.106.1 (user setup)
Commit: cb1933bbc38d329b3595673a600fab5c7368f0a7
Date: 2025-11-16T10:20:23.745Z
Electron: 37.7.0
ElectronBuildId: 12781156
Chromium: 138.0.7204.251
Node.js: 22.20.0
V8: 13.8.258.32-electron.0
OS: Windows_NT x64 10.0.26100

Extension Version: 25.3.1

Sample Code:

create or replace PROCEDURE BOOLEAN_TEST ( 
 	P_INPUT IN NUMBER 
	,P_INPUT2 IN NUMBER 
	,P_OUT_BOL OUT BOOLEAN 
	,P_OUT_VAL OUT NUMBER 
) 
IS 
BEGIN 
	P_OUT_VAL := P_INPUT + P_INPUT2; 

	IF MOD(P_OUT_VAL, 2) = 0 
	THEN 
		P_OUT_BOL := TRUE; 
	ELSE 
		P_OUT_BOL := FALSE; 
	END IF; 

	DBMS_OUTPUT.PUT_LINE('P_OUT_VAL: ' || P_OUT_VAL); 
	DBMS_OUTPUT.PUT_LINE('P_OUT_BOL: ' || CASE WHEN P_OUT_BOL THEN 'TRUE' ELSE 'FALSE' END); 

END BOOLEAN_TEST;

Steps:

Run the code, in my case i passed P_INPUT = 11 and P_INPUT2 as 2. The results appear in SCRIPT OUTPUT.

Note: the P_OUT_BOL line is from my DBMS_OUTPUT statement. When you click “P_OUT_BOL” tab, no value is displayed

However, P_OUT_VAL has the expected value

Comments
Post Details
Added 2 days ago
0 comments
31 views