How to find Oracle Package Errors with query

You can find oracle package errors by executing the query below.

select e.owner,e.type,e.line, e.position,e.text, substr(s.text,1,500) source 
from dba_errors e, dba_source s 
where e.name=upper('YOUR_PACKAGE_NAME_HERE') 
and s.name=e.name 
and e.line =s.line 
order by 1,2,e.SEQUENCE;