Home » SQL & PL/SQL » SQL & PL/SQL » Triggers Timings
Triggers Timings [message #204975] Wed, 22 November 2006 23:52 Go to next message
balumeignanam
Messages: 8
Registered: November 2006
Location: Bangalore
Junior Member

Hi all

i have two triggers A and B both are before insert in same table .But i want to fire the trigger B first, how to work it out.
Re: Triggers Timings [message #204991 is a reply to message #204975] Thu, 23 November 2006 00:27 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Merge both triggers into one. Put trigger B code at the beginning of the trigger and trigger A code at the end, so you'll have your sequence. After all, both are BEFORE INSERT triggers on the same table.
Re: Triggers Timings [message #204993 is a reply to message #204975] Thu, 23 November 2006 00:28 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Combine them into one trigger and put the code from B before the code from A.
There is NO way to force any order of triggers on the same triggering event and level.

[Edit: Littlefoot beat me to it, but it looks quite clear what the idea is...]

[Updated on: Thu, 23 November 2006 00:29]

Report message to a moderator

Re: Triggers Timings [message #205096 is a reply to message #204993] Thu, 23 November 2006 05:21 Go to previous messageGo to next message
balumeignanam
Messages: 8
Registered: November 2006
Location: Bangalore
Junior Member

Hi
Thanks For your Comment...
Re: Triggers Timings [message #205111 is a reply to message #204993] Thu, 23 November 2006 06:10 Go to previous messageGo to next message
orafaqer
Messages: 48
Registered: July 2006
Member
Frank wrote on Thu, 23 November 2006 09:28
Combine them into one trigger and put the code from B before the code from A.
There is NO way to force any order of triggers on the same triggering event and level.

[Edit: Littlefoot beat me to it, but it looks quite clear what the idea is...]

It will be in 11g.
Re: Triggers Timings [message #205114 is a reply to message #205111] Thu, 23 November 2006 06:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Interesting.
I wonder why?
Re: Triggers Timings [message #205131 is a reply to message #205114] Thu, 23 November 2006 07:11 Go to previous message
orafaqer
Messages: 48
Registered: July 2006
Member
JRowbottom wrote on Thu, 23 November 2006 15:18
Interesting.
I wonder why?

Who knows. To add new bugs feature, for instance.
Previous Topic: Identifying and extracting an old data over three years
Next Topic: Integer Representation in oracle
Goto Forum:
  


Current Time: Wed Dec 07 03:10:07 CST 2016

Total time taken to generate the page: 0.06539 seconds