Re: Is there a way to check which procedure, stored procedure is not compiled.

"rangdalf" <rangdalf_at_hotmail.com> a écrit dans le message de news:fd099c36.0411040131.788c1f85_at_posting.google.com...
> Hello,
>
> I would like to know if it is possible to write a script or function
> which check all procedures, functions, stored procedures and display
> which one are not compiled.
>
> thanks in advance for your help.
>
> Rangdalf

There is no need to know that as Oracle dynamically recompiles invalid objects. It's more important to know which ones contain errors with: select distinct owner, name, type from dba_errors;

-- 
Regards
Michel Cadot