dbms_alert package
From: Mike Campbell <mlcampb1_at_mikec.b30.ingr.com>
Date: 17 Feb 1994 21:16:37 GMT
Message-ID: <2k0mrl$efq_at_b30news.b30.ingr.com>
PL/SQL: Statement ignored
Date: 17 Feb 1994 21:16:37 GMT
Message-ID: <2k0mrl$efq_at_b30news.b30.ingr.com>
What is the proper way to use the dbms_alert package supplied in V7. I
am trying to use the example in the Application Developer's Guide on
page A-19
and it says to create a trigger on the emp table that looks like this:
create trigger emptrig after insert or update or delete on emp
begin
dbms_alert.signal('emp_table_alert','message_text');
end;
But when I do this from within SQL*Plus I get the following errors:
ORA-06550: line 3, column 1: PLS-00201: identifier 'DBMS_ALERT' must be declared ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
What do I need to do to declare the dbms_alert package.
Mike Campbell Phone : (205)730-3623 Senior Customer Application Engineer Internet : mlcampb1_at_ingr.com Intergraph Corp. Fax : (205)730-3300 Huntsville, AL 35894-0001 Mailstop : GD3002Received on Thu Feb 17 1994 - 22:16:37 CET