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 -> Re: DBMS_OUTPUT.ENABLE doesn't work.

Re: DBMS_OUTPUT.ENABLE doesn't work.

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/03
Message-ID: <3434DD86.1B420189@gatwick.geco-prakla.slb.com>#1/1

The DBMS_OUTPUT.ENABLE procedure merely determines the size of your output buffer (default 2000, max 1000000) and is not a substitute for set serveroutput on.
If having to issue the set serverout on command is too much of a pain you could try setting it in a login.sql. As long as the directory which contains login.sql is specified in the users SQLPATH environment variable is should automatically execute the contents of the login.sql.

Hope this helps,

Ian Received on Fri Oct 03 1997 - 00:00:00 CDT

Original text of this message

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