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: Problem with DBMS_OUTPUT

Re: Problem with DBMS_OUTPUT

From: Thomas Busl <thomas.busl_at_micromet.de>
Date: Fri, 16 Apr 1999 08:41:18 +0200
Message-ID: <3716DB8E.345CBAC8@micromet.de>


Dear Paul,
if you use sqlplus you have to set: set serveroutput on or normally dbms_output.enable
so long
thomas
Paul Davies wrote:

> I cannot get my DBMS_OUTPUT working.
>
> The following statement in SQL Plus produces no output:
>
> BEGIN
> DBMS_OUTPUT.PUT_LINE('Hello world');
> END;
>
> does not work though I get the "PL/SQL Procedure successfully completed"
> message.
>
> Is there some configuration I need to do so DBMS_OUTPUT is echoed to the
> terminal?
>
> Any help appreciated.
>
> Paul
Received on Fri Apr 16 1999 - 01:41:18 CDT

Original text of this message

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