Dbms problem.

From: Satish Narasimha <satishn_at_blr.sni.de>
Date: 1997/11/21
Message-ID: <34757B19.4C11@blr.sni.de>#1/1

Hello,

    Can anybody tell how to solve this error?

SQL> create trigger emptrig after insert or update or delete on emp   2 begin
  3 dbms_alert.signal('emp_table_alert', 'message_text');   4 end;
  5 /
create trigger emptrig after insert or update or delete on emp *
ERROR at line 1:

ORA-06550: line 3, column 1:
PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared
ORA-06550: line 3, column 1:

PL/SQL: Statement ignored

Thanks in advance.

from
satish:satishn_at_blr.sni.de Received on Fri Nov 21 1997 - 00:00:00 CST