-
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 erbian
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]
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
|