Re: SET SERVEROUTPUT ON doesn't work

In <4vnl2r$doi_at_grandcanyon.binc.net>, skell_at_binc.net (Steven Kell) writes:
>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!
>

There is a script in /rdbms72/admin subdir called dbmsotpt.sql that creates the dbms_output package. Run it connected as SYS. BTW, this script is usually ran when installing the procedural option. Have you been able to create a pl/sql procedure without errors? If not, run catproc.sql in the same sub-directory connected as SYS.

M.Landa Received on Mon Aug 26 1996 - 00:00:00 CEST