Trigger in Package [message #334654] |
Thu, 17 July 2008 10:28  |
dheuschkel
Messages: 14 Registered: March 2007
|
Junior Member |
|
|
Hi!
I would like to know, if it is possible to create a trigger in a package. And if, how the trigger fires.
Thank you in advance
Dagmar
|
|
|
|
|
|
Re: Trigger in Package [message #334833 is a reply to message #334654] |
Fri, 18 July 2008 05:04  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Technically, you cold create a trigger from within a package using dynamic SQL, but there is no reason on earth why you would do that.
It would be a terrible piece of design. The only time it would work without causing a serious performance problem and compromising the quality of your data is if you were the only user accessing a table, in which case you don't need the trigger, as you can just get your code to insert the correct data into the table to start with.
|
|
|