Dependency and Recompilation Confused

[ajhull]

I have been reading Couchman's book and working with STS software. I am confused by some information that is presented regarding dependency and implicit/explicit recompilation of dependent procedures, functions and package bodies.

For example, if TABLE A is recompiled and there is a dependency from a PROCEDURE in a package body on TABLE A, will the recompile of the package body happen explicitly (manually by the user) of implicitly (automatically with next execution of procedure)?

In general, when do recompiles of procedures, functions and package bodies that are dependent on an object (that has been recompiled) happen automatically without user intervention?

Thanks in advance for your reply

Adrian

 

[sem]

Upon an appropriate call. You may also get an error if trying repeatedly execute the code invalidated between invocations.