Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with DBMS_OUTPUT
In article <7f706d$2gh$1_at_hdxl22.telecom.ptt.nl>,
H.C.Ritzema_at_mailgate.telecom.nl says...
>
>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
>
>
Goeiendag
Received on Fri Apr 16 1999 - 04:43:24 CDT
![]() |
![]() |