RE: dbms_utility.compile_schema

[Kathy Duret]

Package bodies, procedures, function in packages need to be compiled before packages.  DBMS_UTILITY.compile_schema I believe compiles in Alphabetically order not in functional order.   Kathy -----Original Message----- From: Big Planet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Subject: dbms_utility.compile_schema Is there something wrong with dbms_utility.compile_schema . When I tried to use it  , I left with few invalid objects . But if I manually compile those objects using alter package *** . they get compiled . Any Idea why ?   BIgP   Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed.  If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.