Re: SET SERVEROUTPUT ON doesn't work

Setting SERVEROUTPUT ON should work, if this is set outside the PL/SQL code. I was never successfull at getting DBMS_OUTPUT.ENABLE to work but you don't need both statements for DBMS_OUTPUT to work.

Maybe someone else can tell us why DBMS_OUTPUT.ENABLE doesn't work.

Scott

Steven Kell wrote:
>
> I'm new to Oracle and PL/SQL, and was writing a simple procedure, when I
> decided that I'd like to see some debugging type info. I tried the
> DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried DBMS_OUTPUT.ENABLE,
> and that didn't work either. I then tried SET SERVEROUTPUT ON, and that gave
> the following message:
>
> SQL> set serveroutput on;
> ERROR:
> ORA-06550: line 1, column 19:
> PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> So, what gives? This is supposed to be a "standard" Oracle function/package,
> isn't it? If anyone out there has any ideas, I'd be glad to hear them.
>
> Thanks!
  Received on Mon Aug 26 1996 - 00:00:00 CEST