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

Collapse
3: Re: TIP 65: (proposed) Modify APM to recompile busted Oracle PACKAGE and PACKAGE BODY objects after upgrade (response to 1)
Posted by Dirk Gomez on 05/27/04 02:24 AM
Dosn't Oracle even try to recompile invalid objects automatically?

(It certainly does try it for views. IIRC it does try it for package bodies as well)

Collapse
5: Re: TIP 65: (proposed) Modify APM to recompile busted Oracle PACKAGE and PACKAGE BODY objects after upgrade (response to 3)
Posted by Andrew Piskorski on 05/27/04 04:05 PM
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.