Re: Help with DBMS_OUTPUT

From: Ken Denny <kedenny_at_mail.concentric.net>
Date: 1996/02/08
Message-ID: <4fe1au$fe0_at_spectator.cris.com>#1/1


aj583_at_lafn.org (Steve Newhouse) wrote:
>godzilla_at_seuss.cc.utexas.edu (Jim Lyons) wrote:
>
>>I am not able to use the supplied packages. In particular, I cannot seem
>>to use DBMS_OUTPUT. Below is a very simple routine I tried to run. In
>>past incarnations I tried doing DBMS_OUTPUT.ENABLE first, but it made no
>>difference so I did not include it here. I have also tried this within
>>a procedure, but got the same results. The program is called testproc.sql
>>and is only 4 lines long:
 

>>begin
>> DBMS_OUTPUT.PUT_LINE ('hello, world!');
>>end;
>>/
 

>>Upon completion, I get the message:
 

>>PL/SQL procedure successfully completed.
>
>Add to the beginning of the PL/SQL procedure:
>DBMS_OUTPUT.ENABLE();
>
That's probably not the problem. The problem is probably that you need to

    SET SERVEROUTPUT ON;
prior to running the procedure.

Ken Denny
Standard disclaimer Received on Thu Feb 08 1996 - 00:00:00 CET

Original text of this message