javakid1993 javakid1993 - 1 year ago 214
SQL Question

Oracle output in sqlplus

I have an oracle stored procedure which has output to the users in the form of


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?


Answer Source

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

SET serververoutput ON;


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download