Version : 10.2.0.1.0
After every import, we compile all the codes using
EXEC DBMS_UTILITY.compile_schema(schema => 'SCOTT');
But this doesn't print the Warnings for each uncompiled procedure/package/function after the compile attempt by DBMS_UTILITY.compile_schema.
Of course, i can see all invalids using
select object_name,object_type where status != 'VALID'
after running DBMS_UTILITY.compile_schema.
But is there any way i can see all the objects which are compiling with Warnings when DBMS_UTILITY.compile_schema is being run?