Database Administration (MOSC)

MOSC Banner

Sequence the trigger execution order

edited Sep 30, 2013 7:07AM in Database Administration (MOSC) 2 commentsAnswered
Hi

We have an after update trigger for a table. We want to add another trigger for the same table after update event. We prefer this way in order to keep the original trigger intact without any changes.

Our requirement is to ensure the trigger that existed already should execute first when an update happens. Then the new trigger should run. Is their any way to control the sequence of execution for the triggers within a table. How can this be achieved?

Any help on this is very much appreciated.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center