Re: Execute Immediate 'SET SERVEROUTPUT ON'; question

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Fri, 20 Apr 2001 16:46:26 +0200
Message-ID: <9bplp9$v0k$1@papyrus.erlm.siemens.de>

That's a sql*plus command. In PL/SQL use dbms_output.enable;
(after the begin).

Klaus
S K <s.kartal_at_gte.net> schrieb in im Newsbeitrag: hwXD6.100$i%5.59701_at_dfiatx1-snr1.gtei.net...
> Hi,
>
> I'm really new to the Oracle Environment and I would like to know how to
> execute SET statements from withing PL/SQL. I feel like I've tried every
> kind of syntax and location before and after the BEGIN.
>
> Currently, I thought I could execute the SET statement
>
> SET SERVEROUTPUT ON
>
> before the begin, but I get an error. If I move the SET statement to
after
> the BEGIN with the syntax
>
> EXECUTE IMMEDIATE 'SET SERVEROUTPUT ON';
>
> I still get an error. Can someone please help me?????
>
> Thank you.
>
> Suzan
>
>
Received on Fri Apr 20 2001 - 09:46:26 CDT