select *
from user_objects where object_type in ('PACKAGE','PACKAGE
BODY','FUNCTION','PROCEDURE','TRIGGER','VIEW')
and status='INVALID'
"rangdalf" <rangdalf_at_hotmail.com> wrote in message
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
Received on Thu Nov 04 2004 - 07:35:33 CST
