procedures status become invalid??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: procedures status become invalid??

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    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

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Are privileges being changed, indexes being dropped, views being modified and/or someone changing procedures/functions/packages without you knowing it ?

  3. #3
    Join Date
    Dec 2006
    Location
    hyderabad
    Posts
    21
    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

  4. #4
    Join Date
    Jul 2006
    Posts
    96

    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
  •  


Click Here to Expand Forum to Full Width