Confused about recompilation...

[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

 

[mhusain]

Please read the following

Managing Local Dependencies

In the case of local dependencies, the objects are on the same node in the same database. The
Oracle Server automatically manages all local dependencies using the database’s internal
“depends-on” table. When a referenced object is modified, the dependent objects are invalidated.
The next time an invalidated object is called, the Oracle Server automatically recompiles it.

I hope this helps.

Mohammad

 

[ajhull]

Thanks for your help. I am now finished all the exams.

Adrian