ORACLE - Show errors

To identify compilation errors in triggers and procedures

SQL>show errors trigger UT_AUTONUMUPD;

LINE/COL ERROR

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

1/14     PL/SQL: Statement ignored

1/14     PLS-00905: object MY_GPAUTONUMLOG is invalid

* MY_GPAUTONUMLOG is a procedure

SQL>show errors procedure MY_GPAUTONUMLOG;

Errors for PROCEDURE MY_GPAUTONUMLOG:

LINE/COL ERROR

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

1/1507   PL/SQL: SQL Statement ignored

1/1519   PL/SQL: ORA-00942: table or view does not exist

Check the procedure MY_GPAUTONUMLOG procedure.