Re: dbms_output.put_line()??

Make sure you have execute access to the DBMS_OUTPUT procedure. Try describing it. If that fails see your DBA. Watch out for the small size of default buffer. Use
SET SERVEROUTPUT ON SIZE 10000
for a 10K buffer. I think the limit is 2Mb (this may be O/S dependent).

PGY

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 Fri Sep 22 2000 - 18:25:59 CDT