以下是我写的一个DB Trigger,但是无论如何无效,请帮忙看看怎么回事。
CREATE OR REPLACE TRIGGER QAP_INVOICE_DISTRIBUTIONS_BRI BEFORE UPDATE
ON ap.ap_invoice_distributions_all
FOR EACH ROW
when(NVL(NEW.match_status_flag, 'N')IN ('A','T', 'S'))
begin
update ap_invoices_all ai
set ai.global_attribute14 = :old.last_updated_by
where ai.invoice_id = :old.invoice_id;
exception
when others then
fnd_message.set_name('FND',