OraFAQ Forum: SQL & PL/SQL » Disable a Trigger by another trigger

Home » SQL & PL/SQL » SQL & PL/SQL » Disable a Trigger by another trigger (PL/SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Disable a Trigger by another trigger [message #307904]

Thu, 20 March 2008 05:38

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?

Report message to a moderator

Re: Disable a Trigger by another trigger [message #307906 is a reply to message #307904]

Thu, 20 March 2008 05:44

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: Disable a Trigger by another trigger [message #307907 is a reply to message #307906]

Thu, 20 March 2008 05:50

ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India

Junior Member

Thanks

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 04:28:42 CST 2025