Re: dbms.enable fails....

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