Re: Recompiling invalid objects with a batch file
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 10 Jun 2008 23:00:49 +0200
Message-ID: <484eeb80$0$2862$ba620e4c@news.skynet.be>
Date: Tue, 10 Jun 2008 23:00:49 +0200
Message-ID: <484eeb80$0$2862$ba620e4c@news.skynet.be>
gazzag schreef:
>
> Sorry, in my previous post "ALTER <object_type> <object_name>
> RECOMPILE;" should be "ALTER <object_type> <object_name> COMPILE;"
>
> COMPILE *not* RECOMPILE.
>
> Apologies.
>
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