Re: SET SERVEROUTPUT ON doesn't work

From: Venkateswara R Polisetti <vrao_at_sctcorp.com>
Date: 1996/08/26
Message-ID: <1996Aug26.115907.8498_at_mcrcr6>#1/1

skell_at_binc.net (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!

I think you do not have the dbms_output package installed on your system. Execute the following query to check to see if it exists.

SELECT *
 FROM all_objects
WHERE object_name = 'DBMS_OUTPUT';

If the above query does not return any rows then you donot have the package installed on your system.

To install the packege run the following script in the directory :

$ORACLE_HOME/rdbms/admin/dbmsotpt.sql  

as SYS user.

Good luck,
Venkateswara Rao

/-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-\

| Venkateswara R.Polisetti                 Email: vrao_at_sctcorp.com  |
| SCT Utility Systems, Inc.             Phone(O): (803) 935-8160    |
| 9 Science Court                            (R): (803) 736-1609    |
| Columbia, SC  29203-9344                                          |

\-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-/ Received on Mon Aug 26 1996 - 00:00:00 CEST