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: Huub Ritzema <H.C.Ritzema_at_mailgate.telecom.nl>
Date: 16 Apr 1999 09:34:05 GMT
Message-ID: <7f706d$2gh$1@hdxl22.telecom.ptt.nl>


In article <370d53c9.0_at_newsread3.dircon.co.uk>, cobalt_at_dircon.co.uk says...
>
>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
>
>
>
>
>

Try this:

Set serveroutput on

BEGIN
        DBMS_OUTPUT.PUT_LINE('Hello World');
END; Set serveroutput off Received on Fri Apr 16 1999 - 04:34:05 CDT

Original text of this message

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