Home » SQL & PL/SQL » SQL & PL/SQL » Trigger (Oracle 9i)
Trigger [message #446807] Wed, 10 March 2010 09:32 Go to next message
Messages: 31
Registered: November 2009
Location: Bangalore
Hi Experts,
Can we call trigger in another trigger,if it is possible please give me one example.

Thanks in advance

Re: Trigger [message #446809 is a reply to message #446807] Wed, 10 March 2010 09:35 Go to previous message
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.
Previous Topic: Calling a function in a package (merged by CM)
Next Topic: Materialize View
Goto Forum:

Current Time: Fri Aug 18 20:52:43 CDT 2017

Total time taken to generate the page: 0.25544 seconds