Re: Execute Immediate 'SET SERVEROUTPUT ON'; question

Hello, PL/SQL does not support 'set' statements. Try dbms_output.enable

Sushmita Dama wrote:

> 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 Tue Apr 24 2001 - 15:15:14 CDT