Re: DBMS_OUTPUT.PUT_LINE does not work
From: Thomas Jegen <thomas.jegen_at_siemens.ch>
Date: Mon, 17 Dec 2001 09:08:49 +0100
Message-ID: <3C1DA811.6FB328D5_at_siemens.ch>
Date: Mon, 17 Dec 2001 09:08:49 +0100
Message-ID: <3C1DA811.6FB328D5_at_siemens.ch>
Hi
When you are using SQL*Plus you have to enter "set serveroutput on" before executing a PL/SQL-Program which is using DBMS_OUTPUT.
Thomas
Stefan Röhle wrote:
>
> Hi,
>
> I tried to use DBMS_OUTPUT.PUT_LINE('test') with a stored procedure, but
> I get no output, although I have written DBMS_OUTPUT.ENABLE; before.
> Or doesn't it work with SQL+ or SQLWorksheet?
> I just want to see if my stored procedure does the right things...
>
> Stefan
-- _______________________________________________________________________ Siemens Switzerland Ltd, Software House, ES41 Thomas Jegen Albisriederstrasse 245, CH-8047 Zürich Phone +41 585 583 438, Fax +41 585 545 340 mailto:thomas.jegen_at_siemens.com, Internet: http://www.siemens.ch/Received on Mon Dec 17 2001 - 09:08:49 CET