I'm just getting into PL/SQL, and I tried to run the following code, and I am getting anonymous block completed, but I think I should be getting Testing output. Does any know what I am doing wrong?
message varchar2(20) := 'Testing output';
Viewing the DBMS_OUTPUT depends on the program.
SQL*Plus and Oracle SQL Developer
SET SERVEROUTPUT ON; first. This is all that's necessary in SQL*Plus or recent versions of Oracle SQL Developer.
SET SERVEROUTPUT ON; begin dbms_output.put_line('Testing output'); end; /
Output is automatically detected and displayed in the "Output" tab.