Oracle: What SQL for "show error" command?

Question

When compiling a package or stored procedure in SQL*Plus, show errors is used to display any errors from the last compilation.

What is the equivalent SQL query to fetch this information?

halfer · Accepted Answer · 2023-07-19 14:42:29Z

4

You want to look at one of the _ERRORS views - either USER_ERRORS, ALL_ERRORS, or DBA_ERRORS. For example:

SELECT *
  FROM DBA_ERRORS
  WHERE OWNER = 'YOUR_SCHEMA' AND
        NAME = 'WHATEVER'
  ORDER BY SEQUENCE

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Mar 10, 2015 at 2:47

50.2k10 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1