CODEWITHSUNDEEP
oracle-database
Mohit
Mohit

Reputation: 43

How to fetch oracle error codes in a query

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?

Upvotes: 0

Views: 409

Answers (2)

Aramillo
Aramillo

Reputation: 3216

More specific:

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

Upvotes: 1

starko
starko

Reputation: 1149

You can use: 

select * from all_errors

In this table have all errors:)

Upvotes: 2

Related Questions