Oracle output in sqlplus

oracle, oracle11g, sql, sqlplus, stored-procedures

Solution

You need set your server output to on by this command:

SET serveroutput ON;

Cheers!

Problem

I have an oracle stored procedure which has output to the users in the form of ``` DBMS_OUTPUT.PUT_LINE('....'); ``` I run the stored procedure through .sql file in sqlplus and none of the output messages of the stored procedures are being shown in sqlplus command window. How could I get the outputs to show in the command window? Thanks,

Original source