Re: Recompile invalid packages

In addition to the other fine answers, also look at ORACLE_HOME/rdbms/admin/utlirp.sql to recompile all invalid objects.

HTH,
Brian

Julien wrote:
>
> Hi,
>
> Do you know how can i recompile invalid package on SQL+ ?
>
> So, i know to do this on Toad but i need a command for SQL+
>
> Thanks,
> Julien.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"