procedures status become invalid??

hi friends,

some times I observed that stored procedues status becomes invalid (in user_objects view) even though there are no alterations on related table structures?
is there any other reason for invalidity?

thanks

Are privileges being changed, indexes being dropped, views being modified and/or someone changing procedures/functions/packages without you knowing it ?

Object status becomes invalid when depending objects r modified or

dropped

or
when any upgradation is in process

or
when any patch is being applied at application level or DB level

hi ebrin, but there are no changes reg. objects like index,views,
tables etc... but let met know if u have any more idea.
but i have to check wheather it will become invalid, when
we change procedure/function that is being called from
a procedure.




[QUOTE=ebriaAre privileges being changed, indexes being dropped, views being modified and/or someone changing procedures/functions/packages without you knowing it ?[/QUOTE]