Re: Help with DBMS_OUTPUT
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