How can I see output of dbms_output.put_line() in SQL window in PL/SQL Developer?

Question

I'm not able to see the messages added to dbms_output.put_line() in PL/SQL Developer. Every google hit I see says to use set serveroutput on but this isn't working.

I try to run this script in a SQL Window:

set serveroutput on;

BEGIN
    dbms_output.put_line('hello')
END

But I get an error on the set serveroutput on line:

And I get no output in the Output tab (regardless of whether I have the set serveroutput on):

How can I see the output sent to dbms_output.put_line('hello') in a script run in an SQL Window?

Thank you.

William Robertson · Accepted Answer · 2022-03-27 22:19:01Z

2

That is because in PL/SQL Developer, a SQL Window can only contain either SQL or PL/SQL blocks. There is a checkbox for enabling or disabling dbms_output. SQL windows aren't really for scripts, unless the 'script' is a set of SQL queries or PL/SQL blocks and nothing else.

(If there is more than one statement in the window, it may be helpful to add / as a terminator after the PL/SQL block, otherwise PL/SQL Developer won't know where one statement ends and the next begins unless you explicitly highlight it with the mouse.)

Alternatively, you could use set serverout on in a Command window (which is a SQL*Plus emulator), or better, use a Test window, which is specifically designed for executing PL/SQL blocks.

edited Mar 27, 2022 at 22:19

answered Mar 27, 2022 at 22:05

William Robertson

16.2k4 gold badges40 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gib65 Over a year ago

Thanks for your answer William. That certainly helps.

Collectives™ on Stack Overflow

How can I see output of dbms_output.put_line() in SQL window in PL/SQL Developer?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related