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: enabling dbms_output.put_line without giving set serveroutput on

Re: enabling dbms_output.put_line without giving set serveroutput on

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Fri, 26 Nov 1999 08:09:30 -0800
Message-ID: <81m7on$l7h$1@inet16.us.oracle.com>


 To see output from DBMS_OUTPUT.PUT_LINE and similar calls in SQL*Plus or Server Manager use the command:

 SET SERVEROUTPUT ON  This causes SQL*Plus / Server Manager to use DBMS_OUTPUT.GET_LINES to read the output and writes it to the terminal.

Anurag <anuragNOanSPAM_at_synergy-infotech.com.invalid> wrote in message news:000b8d9b.cd36510d_at_usw-ex0101-008.remarq.com...
> Hi ,
> How do you enable the output from dbms_output without giving the set
> serverout put on command.
> In the documentation something like dbms_output.enable is given but it
> doesnt work.
> Can somebody please throw some light on it.
>
> Bye
> Anurag
>
> also reply at
> anurag_at_synergy-infotech.com
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri Nov 26 1999 - 10:09:30 CST

Original text of this message

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