Our developers are complaining..the stored proceedures ,functions are getting invalid sometimes in our devlopment environment..can somebody gimme a clue..how i can track what is making them go invalid..
Invalid objects are usually caused by missing grants, synonyms, views, tables or packages, but can also be caused by corrupted packages.
Thanks for the help..i would look into that link..
Possible reasons why SP goes invalid
* Any of objects used on SP if altered(table definitaion chaged).
* Data block corruption.
* Synonym refering to table droped.
* revoked grants.
and may be some more reaosons....
Try checking all the objects involved in the PROC if ther table definations are changed.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Thanks for the neat primer :-)
Your developers should be using packages in preference to procedures -- they will get better protection against invalidation of code.
Procedures = bad, packages = good.
Click Here to Expand Forum to Full Width