compile invalid objects

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/compile-invalid-objects-tp1018.html

Hello Erman,

I have compiled invalid objects using adadmin. When I am querying:
select * from dba_objects
where status='INVALID'
and object_name like 'INL%';

output.xls
I am getting the above invalid object. I am recompiling manually
alter package <owner>.<name of the package> compile;
alter package <owner>.<name of the package> compile body;

Completing with errors.