Re: dbms.enable fails....

From: D <asd_at_asdf.com>
Date: Mon, 12 Nov 2001 07:57:41 -0600
Message-ID: <2CC731D71F4638A3.15D0D7D3FD56A5AE.4311BA5E0FD74D6D_at_lp.airnews.net>


Hi Sybrand,

Mia Culpa! and thanks for the correction.

Here is what I was ultimately able to find would work.

SQL> set serveroutput on;
SQL>execute dbms_output.enable;
PL/SQL procedure successfully completed. SQL> execute dbms_output.put_line('stuff'); stuff
PL/SQL procedure successfully completed.

I now understand your original point which was something like 'execute' substitutes for 'begin end' in an anonymous procedure.

Thanks

Don

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tuonftoc8q10d0_at_corp.supernews.com...
> It is
> 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
>
<SNIP> Received on Mon Nov 12 2001 - 14:57:41 CET

Original text of this message