Re: dbms_output.put_line()??

if you want the output displayed, you'll also need to include a call to the dbms_output.enable( ) procedure before the call to dbms_output.put_line. set serveroutput is a SQL*Plus statement that tells SQL*Plus to display the output lines.

the syntax to create a stored procedure named test (in the current schema) would be:

create or replace procedure test
is
begin
  dbms_output.enable(2000);
  dbms_output.put_line('Hello, world');
end;
/

to run the stored procedure, the SQL/Plus syntax is

begin
  test();
end;
/

if you are trying to run an anonymous block, the syntax is

declare
begin
  dbms_output.enable(20000);
  dbms_output.put_line('Hello, world!'); end;
/

"Legend" <legend_at_spacelab.net> wrote in message news:oWxy5.3809$l35.76116_at_iad-read.news.verio.net...
> I am trying to run this simple PL/SQL but it doesn't run.
>
> SQL> set serveroutput on;
> SQL> create or replace test is begin
> SQL> dbms_output.put_line('hello');
> SQL> end;
> SQL> /
> SQL> ** error **unknown dbms_out... command
>
>
> Why??
>
>
>
Received on Thu Sep 21 2000 - 00:00:00 CDT