Re: Problem with DBMS_OUTPUT

Paul,

You need to set the SQL*Plus variable SERVEROUTPUT to ON;

i.e. Within SQL*Plus before running the PL/SQL package type;

SET SERVEROUTPUT ON SIZE 1000000 will allow upto 1,000,000 bytes to be printed out.

Rgds
Andrew

Paul Davies wrote:

> 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 Thu Apr 08 1999 - 23:08:10 CDT