Cannot print to command line in sql plus

Question

I have a procedure created in an external file as

create or replace procedure emp_select
is
begin
    dbms_output.put_line('Hello World');
end;
/

It is run in sqlplus using

@ /pathtofile

It gives procedure created

But exec emp_select; only says procedure executed successfully, but no output on screen

Jon Heller · Accepted Answer · 2015-01-09 03:35:16Z

4

Run this in SQL*Plus first:

set serveroutput on;

answered Jan 9, 2015 at 3:35

Jon Heller

37k6 gold badges84 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1