Trigger problems with 7.2.3

From: Bob Fazio <fazio_at_danet.com>
Date: 1997/04/02
Message-ID: <01bc3f71$48ebd280$64fa03cf@bobfazio.danetinc.com>#1/1

I am running 7.2.3 on an HPUX 10.10 system and this trigger will fail if executed twice.

i.e. it won't replace it will however work find on 7.1.6. Any clues?

CREATE OR REPLACE TRIGGER RTX_001_ai

	AFTER INSERT ON RTX_001
		REFERENCING NEW AS NEW FOR EACH ROW
        WHEN ( NEW.SPECIAL_NUMBER_IND IS NULL OR
              NEW.SPECIAL_NUMBER_IND != 'T')

begin

    update_mpufdtab(nvl(:new.r_p_customer_id,0),

                            nvl(:new.r_p_contract_id,0),
                             nvl(:new.rated_flat_amount,0) +
                             nvl(:new.toll_rate,0) +
                             nvl(:new.tap_net_rate,0) +
                             nvl(:new.tap_tax_rate,0) +
                             nvl(:new.roam_surcharge,0) );

end;
/ Received on Wed Apr 02 1997 - 00:00:00 CST