SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set "serveroutput on" for the current session.

KnightbeatMar 31 2010 — edited Mar 31 2010

I'm still new to PL/SQL and I use "*SET SERVEROUTPUT ON SIZE 100000"* always before I run a PL program block to get dbms_output. I really need to know why should we specify a size in this line & what that size will be applied for. Also I need to know whether there is any possibility to set serveroutput enabled for the current session, rather than running this code line before each and every PL block.

I Tried *"ALTER SESSION SET SERVEROUTPUT ON SIZE 1000000"* ; But it was not successfully executed.

Thanks!

This post has been answered by Prazy on Mar 31 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2010

Added on Mar 31 2010

#for, #on, #session

6 comments

141,816 views