Re: Recompiling invalid objects in PL/SQL

In article <dn6qlh$qef$1_at_news6.zwoll1.ov.home.nl>, Frank van Bortel says...
> Apart from all the good examples, do you realize Oracle will
> recompile on an 'as needed' base?
> So, unless you're not sure weather everything actually will
> compile, there is no reason to.
>

Not necessarily - I beileve that the user trying to execute a package that is invalid will need to have some specific privilege such as

SQL> grant alter any procedure to <user>;

Unless this has changed in 10g?

-- 

jeremy