Display Oracle Function or Package OUTPUT when executed

You can display your own custom comments, debug information or output from a function or package by specifying the output using DBMS_OUTPUT()

If you’re running the code and not seeing the output when executing a command

start by running “set serveroutput on feedback off;”
end by running “set serveroutput off feedback on;”

Tagged: dbms_output, Oracle, output, print, print line, write line, writeline

Posted in: Oracle, PL/SQL, SQL, SQLPlus