Re: Execute Immediate 'SET SERVEROUTPUT ON'; question

Thank you both for the help. I knew about the dbms_output.enable. I didn't know I couldn't execute SET statements from within PL/SQL. I even have the QUE Special Edition Using Oracle8 book that I'm using and it has a PL/SQL example in Chap. 10, Listing 10.1 with the SET statement right before the BEGIN. It confused me.

Suzan

"Klaus Zeuch" <KZeuchnospam_at_hotmail.com> wrote in message news:9bplp9$v0k$1_at_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 - 10:06:20 CDT