Re: Trigger problems with 7.2.3

Bob Fazio wrote:
>
> 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;
> /

What do you mean fail ? Any exceptions ? If yes, what ? Received on Mon Apr 07 1997 - 00:00:00 CDT