Re: Execute Immediate 'SET SERVEROUTPUT ON'; question

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 20 Apr 2001 15:53:16 +0100
Message-ID: <987778418.23283.0.nnrp-10.c30bdde2@news.demon.co.uk>

The others are correct, but the distinction you are looking for is that the 'set' commands are not SQL or PL/SQL. They are SQL*Plus commands. Most of them don't even work in Server Manager.

"S K" <s.kartal_at_gte.net> wrote in message news: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:53:16 CDT