Re: dbms.enable fails....

"D" <asd_at_asdf.com> wrote in message
news:C28F8E17027A11F5.6B3B27B4277D6F26.9EB653B2FD7550EE_at_lp.airnews.net...
>
> "Ron Reidy" <rereidy_at_indra.com> wrote in message
> news:3BEAFDB2.F83CB1A9_at_indra.com...
> <SNIP>
>
> > You cannot execute PL/SQL commands in this manner. You must EXECUTE ...
> > or place the command(s) in an anonomous PL/SQL block. Read the PL/SQL
> > docs.
> <SNIP>
>
> Hi Ron,
>
> You appear to be half right. The following works very well.
>
> SQL> set serveroutput on;
> SQL> begin
> 2 dbms_output.put_line('Look Ma, I can print from PL/SQL!!!');
> 3 end;
> 4 /
> Look Ma, I can print from PL/SQL!!!
>
> PL/SQL procedure successfully completed.
> This code courtesy of http://www.orafaq.org/faqplsql.htm Item entitled
"Can
> one print to the screen from PL/SQL?"
>
> I could not get the 'execute' command to work nor could I find and
> explanation in a document. Good thing for the net, huh!
>
> Thanks
>
> Don
>
>
>

[Quoted] 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