Hi,

I keep getting an error when compiling this trigger. thanks,

I can run the send mail proc by itself, but from within the trigger I get

Error(12,15): PLS-00103: Encountered the symbol "SEND_MAIL" when expecting one of the following: := . ( @ % ; immediate The symbol ":=" was substituted for "SEND_MAIL" to continue.

code

CREATE OR REPLACE TRIGGER "BU_ENTITY_TEST" AFTER
UPDATE OF "FACILITY_MANAGED_SECURITY_FLAG"
ON "ENTITY_TEST" FOR EACH ROW

DECLARE

BEGIN
IF (:NEW.FACILITY_MANAGED_SECURITY_FLAG = -2) THEN

execute send_mail(msg_to=>'somemail@123.com');

END IF;
END bu_entity_test;