Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with DBMS_OUTPUT
Try SET SERVEROUTPUT ON
It's usefull to add it in your login.sql file. It'll always ready when you open a SQL PLUS session.
Paul Davies <cobalt_at_dircon.co.uk> a écrit dans l'article
<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 Fri Apr 09 1999 - 00:10:08 CDT
![]() |
![]() |