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
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 ...