Originally posted by hrishy
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',[b]'M'[b],'S','O','T','Q','L','C','W') OR (NEW.status = 'M' AND NEW.alloc_qty = NEW.quantity)))

regards
Hrishy
Hrishy i dont usderstand ur logic here, but the OR simply is useless...or rather i cud put in words....irrespective of this quantity "NEW.alloc_qty = NEW.quantity" being equal or not ur trigger will fire...


And S logically both trigger wud fire for status='M'

Abhay.