DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: proceedures invalid

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Nagraj

    Thanks for the help..i would look into that link..

    regards
    Hrishy

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Abhay

    Thanks for the neat primer :-)

    regards
    Hrishy

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Your developers should be using packages in preference to procedures -- they will get better protection against invalidation of code.

    Procedures = bad, packages = good.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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