Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Default serveroutput

Default serveroutput

From: Manjunath Aravind <maravind_at_hns.com>
Date: 2000/07/28
Message-ID: <Pine.GSO.4.21.0007281202081.21722-100000@swtsun8.hns.com>#1/1

Whenever I start a SQLPlus session, the default value of serveroutput is OFF. How do I ensure that this default value is ON ? I don't want to do a 'set serveroutput on' everytime I start a session.

Also, executing dbms_output.enable(10000) within my pl/sql code does NOT actually turn serverouput to ON for the current session. Is there any other way, that I can turn serverouput to ON for my session ?

TIA,
-Manju Received on Fri Jul 28 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US