Home » SQL & PL/SQL » SQL & PL/SQL » How to use dll commands using database triggers (Windows XP)
How to use dll commands using database triggers [message #306685] Sat, 15 March 2008 14:19 Go to next message
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.....
Re: How to use dll commands using database triggers [message #306686 is a reply to message #306685] Sat, 15 March 2008 14:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to use dll commands using database triggers [message #306687 is a reply to message #306685] Sat, 15 March 2008 14:26 Go to previous messageGo to next message
BlackSwan
Messages: 25047
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.
Re: How to use dll commands using database triggers [message #306706 is a reply to message #306687] Sun, 16 March 2008 01:41 Go to previous message
Littlefoot
Messages: 20900
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).
Previous Topic: To retrieve first characters before period
Next Topic: Exceptions
Goto Forum:
  


Current Time: Wed Dec 07 14:40:30 CST 2016

Total time taken to generate the page: 0.06601 seconds