Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recompiling invalid objects in PL/SQL

Recompiling invalid objects in PL/SQL

From: <fvanboven_at_gmail.com>
Date: 6 Dec 2005 00:01:05 -0800
Message-ID: <1133856065.502342.302240@o13g2000cwo.googlegroups.com> 





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
Received on Tue Dec 06 2005 - 02:01:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US