Re: Execute Immediate 'SET SERVEROUTPUT ON'; question

From: Sushmita Dama <sdama_at_sprint.ca>
Date: Sun, 22 Apr 2001 16:58:23 -0400
Message-ID: <%wHE6.4200$Ar3.96397@newscontent-01.sprint.ca>

Hi ,

'SET SERVEROUTPUT ON' works when it is issued in sql* plus and also in a script written and executed in Oracle 8. But when I try the same command in PL/SQL ( 8i), I also get an error message.
Any help or suggestions are appreciated. SD.

"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 Sun Apr 22 2001 - 15:58:23 CDT