Hi

I have a trigger somethin like this

CREATE OR REPLACE TRIGGER trg_ext_interface
AFTER UPDATE OF status, alloc_qty ON ORDR
FOR EACH ROW
WHEN ( NEW.source IS NOT NULL AND NEW.external_ref1 IS NOT NULL
AND (NEW.status IN ( 'A','M','S','O','T','Q','L','C','W') OR (NEW.status = 'M' AND NEW.alloc_qty = NEW.quantity)))

CREATE OR REPLACE TRIGGER "testr".trg_ext_interface_mkt
AFTER UPDATE OF alloc_qty on ORDR FOR EACH ROW
WHEN ( new.source is not null and new.external_ref1 is not null
and new.status = 'M' and new.alloc_qty = new.quantity)

when we update the alloc_qty on ordr table do both the triggers fire or only one of the triggers fire ..

regards
Hrishy