Help with DBMS_OUTPUT
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.htmlReceived on Tue Feb 06 1996 - 00:00:00 CET