How to see stored procedure output on command line via sqlplus [duplicate]

Question

CREATE OR REPLACE PROCEDURE TEST_PROC
IS
  str varchar(100);
  rec_count INTEGER;

BEGIN
    str := 'select count(*) from emp_record';
    EXECUTE IMMEDIATE str into rec_count;
    dbms_output.put_line(rec_count);
END;

I can see output of this procedure in Toad(for oracle), but when i execute this in command line via sqlplus i see following output

SQL> exec test_proc;

PL/SQL procedure successfully completed.

so question is how can i see count output on command line.

Already answered in your previous question stackoverflow.com/a/27939284/3989608 — Lalit Kumar B
– Lalit Kumar B, Commented Jan 14, 2015 at 11:01

Frank Schmitt · Accepted Answer · 2015-01-14 10:40:58Z

3

You need to enable the output in SQL/PLUS before running your stored procedure:

SET SERVEROUTPUT ON

answered Jan 14, 2015 at 10:40

Frank Schmitt

30.5k13 gold badges79 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

How to see stored procedure output on command line via sqlplus [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related