Triggers [message #38954] |
Thu, 30 May 2002 15:20 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Can we call a trigger inside another trigger in oracle???
|
|
|
Re: Triggers [message #38955 is a reply to message #38954] |
Thu, 30 May 2002 15:49 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
You can never "call" a trigger - a trigger only fires in response to some event (either DML or certain system events). You can certainly call a procedure or function from within a trigger though.
|
|
|
Re: Triggers [message #38957 is a reply to message #38955] |
Thu, 30 May 2002 19:23 |
satish
Messages: 112 Registered: September 2000
|
Senior Member |
|
|
Hello,
The purpose of Trigger is Trigger will fire only if any DML operation takes place on any table. Otherwise trigger never fire.
Best way you can do is, create two procedure and call one procedure in other procedure.
Hope this helps.
Satish
|
|
|