Ajuste Trigger Update

[rmanParticipante]

@Thiago Jader Macedo da Cruz

Tente da seguinte forma:


CREATE OR REPLACE TRIGGER TGR_ATUALIZA_STATUS
AFTER UPDATE OF TDL_TP_INI, TDL_PAC_REG ON TDL
FOR EACH ROW
BEGIN
IF NEW.TDL_TP_INI IN ('ACOMP', 'HCTI'))
THEN
UPDATE PAC
SET PAC_PRONT_STATUS = 'A'
WHERE ((PAC.PAC_REG = :NEW.TDL_PAC_REG) OR (PAC.PAC_REG = :OLD.TDL_PAC_REG));
ELSE
UPDATE PAC
SET PAC_PRONT_STATUS = 'C'
WHERE ((PAC.PAC_REG = :NEW.TDL_PAC_REG) OR (PAC.PAC_REG = :OLD.TDL_PAC_REG));
END IF;
END;