Oracle output in sqlplus

Question

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,

Before running the script, try writing SET SERVEROUTPUT ON.
– tilley31
Commented Aug 12, 2013 at 23:36 — tilley31, Commented Aug 12, 2013 at 23:36

PhatHV · Accepted Answer · 2016-11-08 01:45:52Z

7

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

SET serveroutput ON;

Cheers!

edited Nov 8, 2016 at 1:45

answered Aug 13, 2013 at 2:33

PhatHV

8,1416 gold badges33 silver badges40 bronze badges

-_-.. sigh, so simple. Thanks! :D
– javakid1993
Commented Aug 13, 2013 at 13:59

Add a comment |

Oğuz Çam · Accepted Answer · 2017-01-03 14:59:04Z

3

PhatHV's answer is correct.

Additionally, you can give size if you want in range 2000 through 1000000. SET serveroutput ON size 2000;

For more detail, you can see https://oracleblogging.wordpress.com/2010/10/08/dbms_output-buffer-set-serveroutput-on-size/

edited Jan 3, 2017 at 14:59

answered Nov 4, 2016 at 8:50

Oğuz Çam

313 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Oracle output in sqlplus

2 Answers 2

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Related