Subject | Re: Cross database update |
---|---|
Author | |
Post date | 2014-11-18T17:37:21Z |
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';
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';