Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with DBMS_OUTPUT
you must do 'set serveroutput on' (see sql*plus manual) before executing the
pl/sql block.
Pei
DBA consultant.
Paul Davies wrote in message <370d53c9.0_at_newsread3.dircon.co.uk>...
>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 Sat Apr 10 1999 - 12:50:38 CDT