I have a package and package body say "A". And when I alter some of the tables referenced by the package body, the status of the package body shows as 'INVALID'.
However if I execute the pacakge it doesn't give me an error and if I check the status again it shows as VALID.
We are running Oracle 220.127.116.11
My questions are
1. Does Oracle automatically recompile the package before executing.
2. Also if a user just has execute priviliges on a package owned by a different user will it still recompile the package?