ADO.NET Batch Update

[MB_KSU]

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?

[Mycroft Holmes]

I would guess that triggers are disabled for batch updates then, probably as a database default. This is a sensible idea, you do NOT want triggers firing in volume and you should be managing your data not relying on a trigger. I hate the bloody things, always causing trouble, hiding under the hood and causing issues bah!

Never underestimate the power of human stupidity RAH

[MB_KSU]

Good idea. I'm not a DBA so do you know for sure if there is an admin option that disable a trigger for batch updates?

[Mycroft Holmes]

MB_KSU wrote:

do you know

No idea, especially on Oracle

Never underestimate the power of human stupidity RAH