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: Lando <MarkL_at_quebim.com>
Date: 1997/10/03
Message-ID: <34353E9F.E61730BB@quebim.com>#1/1

dbms_output.enable() does not set serveroutput on. It only sets the buffer size for
dbms_output put and get statements. Also, by setting serveroutput on you have also
enabled dbms_output by default with the default buffer size.

Eddy Setiawan wrote:

> Hi,
>
> I'm trying to use the DBMS_OUTPUT package to write some reports,
> but in every new session, the command SET SERVEROUTPUT ON need
> to be issued. According to PL/SQL programming book by O'Reily,
> the DBMS_OUTPUT.ENABLE should do the job. I've tried that, but
> it doesn't seems to work. Is there anything that I missed? Your
> kind help is appreciated. TIA.
>
> Regards,
> Eddy Setiawan
> <setiawan_at_singnet.com.sg>
Received on Fri Oct 03 1997 - 00:00:00 CDT

Original text of this message

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