SET SERVEROUTPUT ON doesn't work

From: John Kessel <John.Kessel_at_gca.idn.nl>
Date: 1996/08/26
Message-ID: <029_9608281604_at_idn.nl>#1/1

Steven Kell schreef aan All:

 SK> From: skell_at_binc.net (Steven Kell)
 SK> Date: 24 Aug 1996 19:27:23 GMT
 SK> Organization: Berbee Information Networks Corporation

 SK> I'm new to Oracle and PL/SQL, and was writing a simple procedure,
 SK> when I  decided that I'd like to see some debugging type info.  I
 SK> tried the  DBMS_OUTPUT.PUT_LINE and that didn't compile, so I tried

 SK> DBMS_OUTPUT.ENABLE, and that didn't work either. I then tried SET  SK> SERVEROUTPUT ON, and that gave the following message:

SQL> set serveroutput on;
 SK> ERROR:
 SK> ORA-06550: line 1, column 19:
 SK> PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
 SK> ORA-06550: line 1, column 7:
 SK> PL/SQL: Statement ignored

 SK> So, what gives?  This is supposed to be a "standard" Oracle

 SK> function/package, isn't it? If anyone out there has any ideas,  SK> I'd be glad to hear them.

Maybe you used the previous version of Oracle. I did the same today and with the same results. Or has anyone a better solution ????

John

--
| Standard disclaimer: The views of this user are strictly his own.

Received on Mon Aug 26 1996 - 00:00:00 CEST