Oracle Database Discussions

Hi,

After database import operation I have to recompile all schema objects which become invalidated I used following two procedure to compile them
exec dbms_ddl.alter_compile ('Object-Type','Schema-Name','Object-Name');
exec dbms_utility.compile_schema('Schema-Name');

Both Procedures executed successfully. But when I used user_objects View to check the status of Objects it show me Invalid, furthermore the application code also give me error. What could be possible reason for this and how it could be resolved.

Looking forwards for reply

Regards,

Abbasi