OraFAQ Forum: SQL & PL/SQL » How to use dll commands using database triggers

Home » SQL & PL/SQL » SQL & PL/SQL » How to use dll commands using database triggers (Windows XP)

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

How to use dll commands using database triggers [message #306685]

Sat, 15 March 2008 14:19

sunny_ocp
Messages: 15
Registered: September 2007
Location: Pakistan

Junior Member

I want to use a dll command such as drop table table_name in the database trigger, is it possible ???
If yes then please write me the codings, Thanks.....

Report message to a moderator

Re: How to use dll commands using database triggers [message #306686 is a reply to message #306685]

Sat, 15 March 2008 14:24

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But why do you want to do this?
Don't you like the life?
Why do you want to go to hell now?

Regards
Michel

Report message to a moderator

Re: How to use dll commands using database triggers [message #306687 is a reply to message #306685]

Sat, 15 March 2008 14:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>If yes then please write me the codings
Yes it can be done, but it is a VERY flawed "design" to which I refuse to contribute.

Report message to a moderator

Re: How to use dll commands using database triggers [message #306706 is a reply to message #306687]

Sun, 16 March 2008 01:41

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you, sunny_ocp, explain why do you think you need to use DDL in a trigger? What improvement would it make? Why do you think it is a good idea? Because, in vast majority of cases, you do NOT want to use DDL in triggers.

Obviously - it can be done. Research use of EXECUTE IMMEDIATE and AUTONOMOUS TRANSACTION pragma if your case is one of these that can not be solved otherwise than by using DDL (however, I doubt that this is your case).

Report message to a moderator

Previous Topic:	To retrieve first characters before period
Next Topic:	Exceptions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 18:23:39 CDT 2025