Re: Recompiling invalid objects with a batch file
Date: Tue, 10 Jun 2008 23:00:49 +0200
> Sorry, in my previous post "ALTER <object_type> <object_name>
> RECOMPILE;" should be "ALTER <object_type> <object_name> COMPILE;"
> COMPILE *not* RECOMPILE.
Plus you should cater for package bodies, where the syntax is
alter package amehoela compile body; Received on Tue Jun 10 2008 - 16:00:49 CDT