Home » SQL & PL/SQL » SQL & PL/SQL » Disable a Trigger by another trigger (PL/SQL)
Disable a Trigger by another trigger [message #307904] Thu, 20 March 2008 05:38 Go to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

Can we disable one Trigger through another Trigger, is it possible? can anyone explain me?
Re: Disable a Trigger by another trigger [message #307906 is a reply to message #307904] Thu, 20 March 2008 05:44 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No, since that would be a DDL statement which does an implicit commit, and you can't commit inside a trigger.

There might be some workarounds to that, but that would depend on what you are actually trying to do.
Re: Disable a Trigger by another trigger [message #307907 is a reply to message #307906] Thu, 20 March 2008 05:50 Go to previous message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

Thanks
Previous Topic: Please, need an explanation of select results with multiple left joins
Next Topic: Unions + Grouping
Goto Forum:
  


Current Time: Fri Dec 09 02:06:32 CST 2016

Total time taken to generate the page: 0.07485 seconds