How to fetch oracle error codes in a query

Question

How to fetch error codes of oracle or warning codes? Like when I create a procedure it shows Procedure created with compilation errors.

For seeing the errors I need to write show errors;

Is there any way through which I can get these errors or messages through a sql query?

starko · Accepted Answer · 2015-01-13 13:45:02Z

2

You can use:

select * from all_errors

In this table have all errors:)

answered Jan 13, 2015 at 13:45

starko

1,14911 silver badges26 bronze badges

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

Comments

Aramillo · Accepted Answer · 2015-01-13 13:56:49Z

1

More specific:

select * from SYS.USER_ERRORS where NAME = 'YOUR_PROCEDURE_NAME' and type = 'PROCEDURE'

answered Jan 13, 2015 at 13:56

Aramillo

3,2263 gold badges27 silver badges51 bronze badges