Re: dbms.enable fails....

[Quoted] 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
>
>
>
>
>
Received on Fri Nov 09 2001 - 23:16:58 CET