• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1833
  • Last Modified:

set serveroutput on - Session Level

Hello Friends,

I run a small SQL block and since that involves a lot of dbms_output.put_line statements and therefore have to run the following set options, before running the block:

set serveroutput on size 1000000
set linesize 100

But I have to do this everytime I login to run the block. So,

1) Can I safely assume that these statements only affect my current Oracle session?
2) What should I do to change it for my particular ID? (I don't know if its possible too...)

1 Solution
slightwv (䄆 Netminder) Commented:
1) yes.  To verify this:

--verify on
show serveroutput
--connect to another user from the same sql*plus window
conn user/pass@somedb
--look at serveroutput
show serveroutput

2) Don't know how to sepcifically set it for your specific user w/o some fancy coding.  The easiest way:  Create a login.sql or glogin.sql file.  This will set it for anyone that connects.  Note:  login.sql will only run from the current directory from where you start sql*plus.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now