DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002

    Angry Triggers, Packages, SPs, Decompile

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

    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,

  2. #2
    Join Date
    Nov 2002
    Geneva Switzerland
    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

    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.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.