The simplest way to honor the recommendation that all the PL/ SQL library units that are called from a given top-level unit are compiled in the same mode is to upgrade the whole database so that all PL/ SQL library units are compiled NATIVE. A release soon after Oracle9i Database Version 9.2.0 will include such a script together with its partner to downgrade a whole database so that all PL/ SQL library units are compiled INTERPRETED. Meanwhile, these are posted on OTN here�
//tech/pl_sql/htdocs/README_2188517.htm