Identify invalid objects

select object_name, object_type, status from dba_objects where owner = 'TRAX' AND STATUS = 'INVALID';

---------------------------------------------------------------------------------


OBJECT_NAME OBJECT_TYPE STATUS OWNER
--------------- ------------------- ------- -------
TRAX_GETCALL PROCEDURE INVALID TRAX

----------------------------------------------------------------------------------

SQL> ALTER PROCEDURE TRAX.TRAX_GETCALL COMPILE;

Warning: Procedure altered with compilation errors.

SQL> SHOW ERRORS
Errors for PROCEDURE TRAX.TRAX_GETCALL COMPILE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/3 PL/SQL: SQL Statement ignored
9/39 PL/SQL: ORA-00942: table or view does not exist

Then execute the Get DDL query given in the blog to view the full sqltext body.
=================================================================================

Script to recomplile invalid objects in oracle database

@$ORACLE_HOME/rdbms/admin/utlrp.sql