Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger and Alert question

Trigger and Alert question

From: Li Kong <lkong_at_hns.com>
Date: Thu, 27 May 1999 16:34:43 -0400
Message-ID: <374DAC63.444C7A44@hns.com>


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.com




Received on Thu May 27 1999 - 15:34:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US