Search code examples
plsqldbeaver

DBbeaver PL/SQL why it doesnt use SET SERVEROUTPUT ON?


THIS WORKS

-- SET SERVEROUTPUT ON
 DECLARE
    v_num NUMBER := 0;
 BEGIN
    LOOP
        dbms_output.put_line(' v_num : ' || v_num);
        v_num := v_num + 1;
        EXIT WHEN v_num > 4;
    END LOOP;
 END;
--/

THIS DOESNT AND I HAVE NO IDEA WHY

 SET SERVEROUTPUT ON
 DECLARE
    v_num NUMBER := 0;
 BEGIN
    LOOP
        dbms_output.put_line(' v_num : ' || v_num);
        v_num := v_num + 1;
        EXIT WHEN v_num > 4;
    END LOOP;
 END;
 /

I WAS EXPECTING

1
2
3
4

Solution

  • SET SERVEROUTPUT ON

    Is a command of SQLPLUS (Oracles "command line tool" to access the DB)

    => It is not SQL that you send to the server. It is used on your client.

    As you use a different tool, I assume this is no implemented there...

    And for the specific case ( = you want to view dbms_output output) :

    There is an output tab in DBeaver where the dbms_output occurs ...

    enter image description here