What is the Sequence of Trigger Fire while Committing through Forms?

Oracle Apps Interview Questions › Category: Oracle Forms › What is the Sequence of Trigger Fire while Committing through Forms?
0 Vote Up Vote Down
Questions Master asked 9 years ago

list the sequence in order.

 

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 9 years ago

Here is the sequence of triggers fired while committing:

  1. KEY Commit
  2. Pre Commit
  3. Pre/On/Post Delete
  4. Pre/On/Post Update
  5. Pre/On/Post Insert
  6. On commit
  7. Post Database Commit