-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|