Hello,
I've just did some changes in my plsql packages and I get that some of them are decompiled after the changes. I'll try to explain it:
1- I have a package (PKG1) that call some other packages.
2- I have a synonym for PKG1
3- I created a new package PKG1.1 that call other packages (same packages than PKG1) and a some brand news.
4- I replaced synonym to call new package PKG1.1
5- I get that some "end packages" was decompiled.
The fact is that when I do the "create or replace synonym", PKG1 was in use. My objective doing this is to avoid blocked packages.
Why I get that some packages were decompiled? Maybe is because they were in use when I updated the synonym?
Thank you very much.