DBMS_ALERT package question

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 Received on Thu Feb 27 1997 - 00:00:00 CST