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: Arlette BROSSARD <abray_at_club-internet.fr>
Date: 9 Apr 1999 05:10:08 GMT
Message-ID: <01be8247$9c5a3900$e7a624c3@ntdv2113>


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

Original text of this message

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