Thanks, Kathey. I was starting to look at invalidating all the triggers at hard upgrade time but let me first look at the code you mentioned.
Mamta On Fri, Apr 16, 2010 at 2:31 PM, Kathey Marsden <[email protected]> wrote: > On 4/16/2010 1:25 PM, Mamta Satoor wrote: >> >> Other option would be mark them as invalid so that when they are used >> next time, they will be automatically recompiled. >> >> > > I have not been following this thread, so may be misinterpreting the > question, but I think any stored plan gets recompiled on any version change > in DD_Version handleMinorRevisionChange. > > >
