sql - Oracle output in sqlplus -
i have oracle stored procedure has output users in form of
dbms_output.put_line('....');
i run stored procedure through .sql file in sqlplus , none of output messages of stored procedures being shown in sqlplus command window. how outputs show in command window?
thanks,
you need set server output on command:
set serveroutput on;
cheers!
Comments
Post a Comment