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


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 9.2.0.5

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?

RECOMPILING PACKAGES

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.