Extension version: 26.2.0
VS Code version: 1.129.0
Database versions tested:
Oracle Database 11g Release 11.2.0.4.0 (64-bit) — fails
Oracle Database 19c — works correctly
Description:
When running a script via "Run Script" that calls DBMS_OUTPUT.PUT_LINE, the Script Output panel does not display the output when connected to an 11.2.0.4.0 database. The identical script run against a 19c database displays the output correctly in the same panel.
To rule out a database-side or permissions issue, the same script was run against the same 11g database using standalone SQLcl, and DBMS_OUTPUT was displayed correctly there — indicating the issue is isolated to the extension's Script Output handling for 11g connections.
Steps to reproduce:
-
Connect to an Oracle 11.2.0.4.0 database using the extension
-
Run the following script using "Run Script":
SET SERVEROUTPUT ON; BEGIN DBMS_OUTPUT.PUT_LINE('Hello'); END; /
-
Observe the Script Output panel
Extension version: 26.2.0
VS Code version: 1.129.0
Database versions tested:
Oracle Database 11g Release 11.2.0.4.0 (64-bit) — fails
Oracle Database 19c — works correctly
Description:
When running a script via "Run Script" that calls DBMS_OUTPUT.PUT_LINE, the Script Output panel does not display the output when connected to an 11.2.0.4.0 database. The identical script run against a 19c database displays the output correctly in the same panel.
To rule out a database-side or permissions issue, the same script was run against the same 11g database using standalone SQLcl, and DBMS_OUTPUT was displayed correctly there — indicating the issue is isolated to the extension's Script Output handling for 11g connections.
Steps to reproduce:
Connect to an Oracle 11.2.0.4.0 database using the extension
Run the following script using "Run Script":
SET SERVEROUTPUT ON; BEGIN DBMS_OUTPUT.PUT_LINE('Hello'); END; /Observe the Script Output panel