Email notification in a trigger
754739Mar 17 2010 — edited Mar 18 2010I am trying to create a simple trigger for a table that has only one row. This is for a 10g database.
I can't figure out how to send e-mail. I believe there is some kind of package that i have to include.
Any help would be appreciated.
Thanks.
Shawn
CREATE OR REPLACE TRIGGER "GPFOUNDATION_ACCESS_INDCTR"
AFTER UPDATE OF ACCESS_INDICATOR ON GPFOUNDATION
BEGIN
sys.DBMS_ALERT.SIGNAL('gpfoundation_alert', '');
END;
/