apps-infra

    Forum Stats

  • 3,873,683 Users
  • 2,266,627 Discussions
  • 7,911,600 Comments

Discussions

the priority of triggers

621436
621436 Member Posts: 121
edited Oct 2, 2008 5:46PM in Scheduler
I have a trigger watching on a table. If there is any updates in that table, then the trigger will be fired. But there are a lot of other tasks running in the database. My question is: if an update in that table is sent by a client through JDBC, how soon will the trigger be fired? Will it preempt other tasks in the database or it has some waiting time to be fired? Thanks a lot.
Tagged:

Answers

  • Rnr-Oracle
    Rnr-Oracle Member Posts: 1,269 Employee
    Hi,

    I am not an expert on this but as far as I know the trigger is processed synchronously with the update, in other words the update does not complete until the trigger is processed. The trigger is processed by the same session processing the update and there is no waiting time .

    If the trigger fails the update will not be committed so the trigger has to happen before the update is committed.

    Hope this helps,
    Ravi.
This discussion has been closed.
apps-infra