Help with DBMS_OUTPUT

From: Jim Lyons <godzilla_at_seuss.cc.utexas.edu>
Date: 1996/02/06
Message-ID: <1996Feb6.152139_at_seuss.cc.utexas.edu>#1/1


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.

Everything seemed to go OK, only no output. Do I need to supply something else. I thought the DBMS packages were automatically installed with the product - could the installer have somehow ommitted them? Also, I looked at a file called $ORACLE_HOME/rdbms/admin/dbmsotpt.sql which defines this package. The procedure names are there but they are declarations only. I assume the bodies are elsewhere, but could this be a problem? I am running Oracle7 Server Release 7.1.6.2.0 and PL/SQL Release 2.1.6.2.0, which I believe are supposed to have the DBMS_OUTPUT package.

I appreciate all help.

--
Jim Lyons                     |  Operating Systems Specialist
Computation Center            |  512-475-9331
University of Texas at Austin |  j.lyons_at_cc.utexas.edu
http://www.cc.utexas.edu/~godzilla/jimlyons.html
Received on Tue Feb 06 1996 - 00:00:00 CET

Original text of this message