Trigger not executing when a Batch Update runs.

Question

I am using VB.Net 2008 and ADO.Net to do a Batch Update to our Oracle database. The updates are working, but there is a trigger on the table before the row is updated to enforce a member's termination termination date. So if I was trying to set the termination date (via the batch update) to 31-Jan-2010 but the member had a claim that was processed on 2-Feb-2010 the trigger would force the termination date to be 2-Feb-2010. However, the trigger is NOT executing when the batch update runs?

Is there any Oracle DB Admin option that would disable Triggers on Batch Update?

Answer 1

The alter trigger command can be used to disable a trigger,

ALTER TRIGGER trigger_name DISABLE

This will show the enabled/disabled status of all triggers,

select trigger_name, status from user_triggers

Answer 2

A direct path load through SQL*Loader can disable and reenable triggers as described here

What does the batch update do. Maybe if it does a DELETE+INSERT, rather than an UPDATE, then the trigger won't fire.