CREATE OR REPLACE TRIGGER WHD.DELFKEMPCONN
AFTER UPDATE
OF EMPLOYEESTATUS
ON WHD.EMPLOYEE
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
WHEN (
new.EMPLOYEESTATUS ='402883c621cdb48a0121cdbec1920003'
)
BEGIN
delete FKEMPCONN where employeeid = :old.ID;
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END delFKEmpConn;