Re: DBMS_OUTPUT.PUT_LINE does not work
From: MarkyG <markg_at_mymail.tm>
Date: 17 Dec 2001 03:01:56 -0800
Message-ID: <ab87195e.0112170301.66935e5_at_posting.google.com>
Date: 17 Dec 2001 03:01:56 -0800
Message-ID: <ab87195e.0112170301.66935e5_at_posting.google.com>
You need to SET SERVEROUTPUT ON if running the procedure from SQL*Plus.
M
Stefan Röhle <roehle_at_mail.uni-mainz.de> wrote in message news:<3C1DA109.B866EB62_at_mail.uni-mainz.de>...
> 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
Received on Mon Dec 17 2001 - 12:01:56 CET