ORA-06550: dbms_output problem

From: Andrew Sammut <andrews_at_mincom.com>
Date: Wed, 01 Jul 1998 16:54:08 +1000
Message-ID: <3599DD10.9204A2E9@mincom.com>

Hi all,

I'm in charge of a development database which has been working as expected,
up until this morning. We are now receiving the following error on log in
to the system:

ERROR:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

This error occurs for all but the SYS user. Looking through dejanews, I discovered that I should do the following:

GRANT EXECUTE ON sys.dbms_output TO PUBLIC;

Having performed this, I again tested, and to my dismay, the error still occurs. I have even tried to explicitly grant execute privileges to system (and others) but to no avail.

I have the strangest feeling that something has gone seriously awry, but cannot prove it...

I am running Oracle 7.3.2.2.1 on a Solaris 2.5.1 system (semi patched).

Anybody got any ideas?

tia
andrew
--
 __ _ _ _ _ _ __ _ Andrew Sammut

/| \| || \ | \ | || \ / \ || / \   Systems Administrator/Consultant
|| __ ||-] |\ \| ||-] \=\ || \=\   Mincom Pty Ltd, Mining Technology
\|_|| ||_/ | \_| ||_/ \_/ || \_/   ph 61 7 3303 3027, fax 61 7 3303 3048

# include "standard_disclaimer.h" Received on Wed Jul 01 1998 - 01:54:08 CDT