Re: Recompiling invalid objects in PL/SQL

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

$ORACLE_HOME/rdbms/admin/utlrp.sql
or if including it in a PL/SQL block call

utl_recomp.parallel or utl_recomp.serial

You can find demos in Morgan's Library at www.psoug.org.

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)