Forum OpenACS Improvement Proposals (TIPs): Re: TIP 65: (proposed) Modify APM to recompile busted Oracle PACKAGE and PACKAGE BODY objects after upgrade

Dirk, the short answer is, "no". You can read the old threads for more info, but basically, Oracle does attempt to recompile invalidated packages when they are used, but it does not do it in dependency order so "attempt" is the right word - and the attempt can easily fail.