Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trigger and Alert question
I create a trigger like this:
create or replace trigger audit_callrec
after update or insert or update on callrec
begin
dbms_alert.register('this');
end;
/
I got error message "Warning: Trigger created with compilation errors.".
I use "show errors trigger audit_callrec;" I got "
3/1 PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared 3/1 PL/SQL: Statement ignored
Could anybody tell me why I can't use "dbms_alert(0)"
Thanks alot.
--
Li Kong
Hughes Network Systems
11717 Exploration Lane | Phone:(301)601-7207 Germantown, MD 20876 | Fax:(301)428-2801 | Email:lkong_at_hns.comReceived on Thu May 27 1999 - 15:34:43 CDT