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

Thread: Triggers, Packages, SPs, Decompile

  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Angry Triggers, Packages, SPs, Decompile

    If anyone could help me out I would greatly appreciated it.

    Problem:
    Sometimes triggers, packages and stored procedures within Oracle get decompiled for no apparent reason. To fix the problem all that needs to be done is to recompile the code but that isn't a long term solution. Is there something that needs to be done to stop this from happening?

    Thanks in advance for any help,
    lauren

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you MODIFY or ADD columns in a table, change a view, recompile a proc etc etc any object that depends on the changed object becomes invalid and needs compiling too. Are you sure nothing like that is happening?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  3. #3
    Join Date
    Dec 2002
    Posts
    2

    Talking Thanks!

    Thank you for that I hadn't even thought of that being a possibility. I know that there were changes made that were related to the most recent problem with something not being compiled. I appreciated your reply immensely! Thank you again.

    lauren

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