Re: DBMS_OUTPUT.ENABLE doesn't work.

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1997/10/05
Message-ID: <61706l$7fr@bgtnsc03.worldnet.att.net>#1/1

The "Set serveroutput on" command is local to SQL*Plus, and tells that program to display output received from the server. DBMS_OUTPUT.ENABLE/DISABLE, as I recall, allow you to toggle a flag on the SERVER which tells it whether or not to send the output to the client, i.e. to SQL*Plus.

You do need SET SERVEROUTPUT ON.

regards,

Jonathan Gennick

On 3 Oct 1997 04:17:12 GMT, setiawan_at_merlion.singnet.com.sg (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>

gennick_at_worldnet.att.net Received on Sun Oct 05 1997 - 00:00:00 CDT