Home » SQL & PL/SQL » SQL & PL/SQL » Trigger Related Questions
Trigger Related Questions [message #244726] Wed, 13 June 2007 23:29 Go to next message
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear Friends,

My Oracle Version 9i.Is possible to create DDL statements using
execute immmediate in Trigger.

Expecting Your Replies.,
Re: Trigger Related Questions [message #244728 is a reply to message #244726] Wed, 13 June 2007 23:32 Go to previous messageGo to next message
Messages: 24956
Registered: January 2009
Location: SoCal
Senior Member
Yes, but it is a bad,bad, bad & VERY bad idea to do so.
Re: Trigger Related Questions [message #244756 is a reply to message #244726] Thu, 14 June 2007 01:07 Go to previous message
Michel Cadot
Messages: 63907
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, I wonder what can be the business need to do that.

Previous Topic: can i put "set serveroutput on" inside the procedure ?
Next Topic: self join oracle
Goto Forum:

Current Time: Thu Oct 20 17:02:32 CDT 2016

Total time taken to generate the page: 0.05765 seconds