Re: Trigger and Alert question

From: iwould poker <jclparker_at_jclparker.freeserve.co.uk>
Date: Thu, 27 May 1999 23:27:38 +0100
Message-ID: <7ikgd9$mgv$1@news5.svr.pol.co.uk>

One method create the trigger as sys (make sure you specify the schema = for callrec in the 'after' line.)

    Li Kong wrote in message <374DAC63.444C7A44_at_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 - 17:27:38 CDT