SQL> help show

 SHOW
 ----

 Shows the value of a SQL*Plus system variable, or the current
 SQL*Plus environment. SHOW SGA requires a DBA privileged login.

 SHO[W] option

 where option represents one of the following terms or clauses:
     system_variable
     ALL
     BTI[TLE]
     ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER
        | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
     LNO
     PARAMETERS [parameter_name]
     PNO
     RECYC[LEBIN] [original_name]
     REL[EASE]
     REPF[OOTER]
     REPH[EADER]
     SGA
     SPOO[L]
     SQLCODE
     TT[ITLE]
     USER

 SHOW SPOOL is not available in iSQL*Plus


SQL> show err package your_package_name
No errors.
SQL> show err package body your_package_name
No errors.
SQL>

SQL> CREATE OR REPLACE PROCEDURE TEST_ERRORS(V_IN NUMBER) AS
  2  BEGIN
  3     V_OUT := V_IN * V_IN;
  4     DBMS_OUTPUT.PUT_LINE('output = ' || V_OUT);
  5  END;
  6  /
 
Warning: Procedure created with compilation errors
 
SQL> show errors;
Errors for PROCEDURE U208278.TEST_ERRORS:
 
LINE/COL ERROR
-------- ----------------------------------------------
3/4      PLS-00201: identifier 'V_OUT' must be declared
3/4      PL/SQL: Statement ignored
4/40     PLS-00201: identifier 'V_OUT' must be declared
4/4      PL/SQL: Statement ignored
 
SQL> select * from user_errors;
 
NAME                           TYPE           SEQUENCE       LINE   POSITION TEXT                                                                             ATTRIBUTE MESSAGE_NUMBER
------------------------------ ------------ ---------- ---------- ---------- -------------------------------------------------------------------------------- --------- --------------
TEST_ERRORS                    PROCEDURE             1          3          4 PLS-00201: identifier 'V_OUT' must be declared                                   ERROR                201
TEST_ERRORS                    PROCEDURE             2          3          4 PL/SQL: Statement ignored                                                        ERROR                  0
TEST_ERRORS                    PROCEDURE             3          4         40 PLS-00201: identifier 'V_OUT' must be declared                                   ERROR                201
TEST_ERRORS                    PROCEDURE             4          4          4 PL/SQL: Statement ignored                                                        ERROR                  0
 
SQL>