English 中文(简体)
当批量更新运行时,触发器未执行
原标题:Trigger not executing when a Batch Update runs

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?

有没有Oracle数据库管理选项可以禁用批量更新的触发器?

问题回答

一条直接路径通过SQL*Loader加载可以按照此处描述的方式禁用和重新启用触发器。

批量更新是做什么的?如果它执行的是DELETE+INSERT而不是UPDATE,则触发器不会被触发。

触发器命令可以用来禁用触发器。

ALTER TRIGGER trigger_name DISABLE

这将显示所有触发器的启用 / 禁用状态。

select trigger_name, status from user_triggers




相关问题
Is Shared ReadOnly lazyloaded?

I was wondering when I write Shared ReadOnly Variable As DataType = New DataType() Or alternatively Shared ReadOnly Variable As New DataType() Is it lazy loaded or as the instance initializes? ...

Entertaining a baby with VB.NET

I would like to write a little application in VB.NET that will detect a baby s cry. How would I get started with such an application?

Choose Enter Rather than Pressing Ok button

I have many fields in the page and the last field is a dropdown with list of values. When I select an item in a dropdown and press Enter, it doesn t do the "Ok". Instead I have to manually click on Ok ...

ALT Key Shortcuts Hidden

I am using VS2008 and creating forms. By default, the underscore of the character in a textbox when using an ampersand is not shown when I run the application. ex. "&Goto Here" is not ...

Set Select command in code

On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn t work. What am i doing wrong? protected void bttnView_Click(object sender, ...

Hover tooltip on specific words in rich text box?

I m trying to create something like a tooltip suddenly hoovering over the mouse pointer when specific words in the richt text box is hovered over. How can this be done?

热门标签