Programming Oracle® Triggers and Stored Procedures, Third Edition

9.9. USER_ERRORS

SHOW ERRORS is a SQL*Plus command. It returns information from the USER_ERRORS view, which has the following description:

SQL> desc user_errors
 Name                           Null?    Type
 ------------------------------ -------- ----------------
 NAME                           NOT NULL VARCHAR2(30)
 TYPE                                    VARCHAR2(12)
 SEQUENCE                       NOT NULL NUMBER
 LINE                           NOT NULL NUMBER
 POSITION                       NOT NULL NUMBER
 TEXT                           NOT NULL VARCHAR2(4000)

You can select compiler error results when not running SQL*Plus by querying this view. The USER_ERRORS view contains errors for objects compiled in your schema. ALL_ERRORS and DBA_ERRORS are other views with wider scope. Refer to Chapter 5 for a complete description of the differences between the USER, ALL, and DBA data dictionary views. The following is a description ...