Trigger [message #446807] |
Wed, 10 March 2010 09:32  |
prakashaa
Messages: 31 Registered: November 2009 Location: Bangalore
|
Member |
|
|
Hi Experts,
Can we call trigger in another trigger,if it is possible please give me one example.
Thanks in advance
Prakash
|
|
|
Re: Trigger [message #446809 is a reply to message #446807] |
Wed, 10 March 2010 09:35  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Triggers cannot be called directly - they are only called as a result of DML on the table/view that the trigger is on.
If you do DML inside a trigger, then this can cause other triggers to fire.
|
|
|