Re: DBMS_ALERT package question

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/02/28
Message-ID: <33164416.1426320@nntp.mediasoft.net>#1/1

You cannot create stored objects ( triggers, procedures, views ) that reference object you can see because of some role you have.

To see if you have access to dbms_alert via a role:

SQL> desc dbms_alert.signal
SQL> set role none;
SQL> desc dbms_alert.signal

If the first desc works and the second one doesn't, you have access to dbms_alert via a role and won't be able to create a stored object that references it.

You need to have execute granted directly to you...

On 27 Feb 1997 22:35:24 GMT, zgeist_at_ee.ee.net (Unknown) wrote:

>
>
>Greetings all -
>
>I have the following piece of code:
>
>create or replace trigger triggername
>before insert on tablename
>for each row
>begin
> dbms_alert.signal('CHECK_STATS','blah');
>end;
>
>Which results in the following error:
>
>PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared
>
>
>Could anyone give me some insight into this problem ?
>
>Thanks in advance !!
>
>
>Some additional information: One machine is 7.2.3 and one is 7.3.2
>
>Brett
>zgeist_at_ee.net
>

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Feb 28 1997 - 00:00:00 CST