Re: Recompiling invalid objects in PL/SQL

From: Rob Zijlstra <rj.zijlstra_at_tiscali.nl>
Date: Tue, 06 Dec 2005 09:33:11 +0100
Message-ID: <c5jap11vt6qapotq3jr4g6e16rr520conh@4ax.com>

On 6 Dec 2005 00:01:05 -0800, fvanboven_at_gmail.com wrote:

>Is there a way to recompile all invalid objects in PL/SQL??
>
>Currently we use the build-in functionality of PL/SQL Developer to
>recompile all invalid object after a database update.
>
>But I would like to add this to the end of our update script so the
>database is completely up to date in a single execution batch....
>
>Hope someone knows how to do this.
>
>Greetz,
>
>Frank van Boven

Hi Frank,

Google:
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci938771,00.html

Best Regards

Rob Zijlstra Received on Tue Dec 06 2005 - 02:33:11 CST