procedures status become invalid??

[madhugp]

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

[ebrian]

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

[girirajdba]

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

[madhugp]

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]