Skip to content

DBMS_OUTPUT not displayed in Script Output panel against Oracle 11.2.0.4.0 (works fine on 19c and in standalone SQLcl) #31

Description

@abnhast

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:

  1. Connect to an Oracle 11.2.0.4.0 database using the extension

  2. Run the following script using "Run Script":
    SET SERVEROUTPUT ON; BEGIN DBMS_OUTPUT.PUT_LINE('Hello'); END; /

  3. Observe the Script Output panel

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions