-
proceedures invalid
Hi
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..
regards
Hrishy
-
Invalid objects are usually caused by missing grants, synonyms, views, tables or packages, but can also be caused by corrupted packages.
http://metalink.oracle.com/metalink/...&p_id=104457.1
HTH.
-
Hi Nagraj
Thanks for the help..i would look into that link..
regards
Hrishy
-
Hrishy:
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.
Abhay.
funky...
"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"
-
Hi Abhay
Thanks for the neat primer :-)
regards
Hrishy
-
Your developers should be using packages in preference to procedures -- they will get better protection against invalidation of code.
Procedures = bad, packages = good.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|