Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Retrieve DBMS_OUTPUT.PUT_LINE messages in VS Code

Jared WeinbergerJan 31 2024 — edited Jan 31 2024

I cannot get any output from dbms_output.put_line() in a PL/SQL block even when I run "set serveroutput on" beforehand. I can get the server output with the same code in SQL Developer and SQL*Plus.

Oracle Developer Tools for VS Code version: 21.8.0

Oracle DB version: 19c

VS Code version: 1.85.2

Some example code:

set serveroutput on;
begin
    dbms_output.put_line('Hello, World!');
end;
/

This extension is my favorite way to do Oracle Database development. Good job overall!

Comments
Post Details
Added on Jan 31 2024
2 comments
117 views