Excellent solution Charlie! - E
-----Original Message-----
Sent: Wednesday, September 12, 2001 1:25 PM
To: Multiple recipients of list ORACLE-L
When there are mutiple INVALID objects it can be the case that object Z
uses object Y which uses object X. If X, Y & Z are invalid, you'd need to
invoke dbms_utility.compile_schema up to THREE times if the invalid
objects are compiled in alphabetical order.
My PL/SQL procedure use an invalid object counter and remains in a WHILE
LOOP until the current invalid object count equals the previous loop's
invalid
object count. Once two consecutive dbms_utility.compile_schema results in
the same number of invalid objects, then you can exit out of the loop and
exit the procedure.
-------- Original Message --------
Date: Wed, 12 Sep 2001 10:55:24 -0800
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Package bodies, procedures, function in packages need to be compiled before
packages. DBMS_UTILITY.compile_schemaI believe compiles in Alphabetically
order not in functional order. Kathy
-----Original Message-----
<mailto:[EMAIL PROTECTED]> ]
Sent: Wednesday, September 12, 2001 10:11 AM
To: Multiple recipients of list ORACLE-L
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.
------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from disclosure
under law. If you have received this message in error, please inform us promptly by
reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.
==============================================================================
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
