Home » SQL & PL/SQL » SQL & PL/SQL » Trigger (Oracle 9i)
Trigger [message #446807] Wed, 10 March 2010 09:32 Go to next message
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 Go to previous message
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.
Previous Topic: Calling a function in a package (merged by CM)
Next Topic: Materialize View
Goto Forum:
  


Current Time: Sat Dec 03 18:04:16 CST 2016

Total time taken to generate the page: 0.10507 seconds