Subject Re: Cross database update
Author
And another thing.
Deactivating the triggers is not an option for me but it works.

        execute statement 'alter trigger files_au0 inactive';
        execute statement 'alter trigger files_bu0 inactive';
        execute statement 'alter trigger pool_loss_record_bu0 inactive';
        update files f
            set f.ccy_total_claim_amount_net = :TCACCY,
                f.ccy2_total_claim_amount_net = :TCACCY2,
                f.date_filter = :DATEFILTER
        where f.file_id = :FILE_ID;
        execute statement 'alter trigger files_au0 active';
        execute statement 'alter trigger files_bu0 active';
        execute statement 'alter trigger pool_loss_record_bu0 active';