Re: dbms.enable fails....

It is
[Quoted] dbms_output instead of dbms.output
It is dbms_output.put_line
and dbms_output.enable

The number of people asking for assistance on typo's seems to be rapidly increasing.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address


"D" <asd_at_asdf.com> wrote in message
news:EAEC5E67A53A0646.41B2E019E1D94012.E79491B3C221D8BA_at_lp.airnews.net...


> Hi Sybrand,


>

> Thanks for that clarification. I tested the 'execute' as follows:

>

> -- set the serveroutput

> SQL> set serveroutput on;

> --enter the execute statement

> SQL> execute dbms.output.putline ('stuff');

> --SQL Plus returns first this

> BEGIN dbms.output.putline ('stuff'); END;

> --then this

> ERROR at line 1:

> ORA-06550: line 1, column 7:

> PLS-00201: identifier 'DBMS.OUTPUT' must be declared

> ORA-06550: line 1, column 7:

> PL/SQL: Statement ignored

>

> It appears that 'execute' will not work at all in this particular case.

>

> Any further observations?

>

> Thanks,

>

> Don

>

>

> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message

> news:tuo8p3ml0qtud1_at_corp.supernews.com...

> <SNIP>

> > execute is the _sqlplus_ equivalent of begin end;

> > It is not a pl/sql command, hence you can not use it _inside_ a pl/sql

> > block.

> >

> > Hth

> >

> >

> > --

> > Sybrand Bakker

> > Senior Oracle DBA

> >

> > to reply remove '-verwijderdit' from my e-mail address

> >

> >

> >

> >

> >

>

>