Query to Display Package Errors

The relevant query is as follows:

SELECT text

FROM    dba_errors

WHERE name = ‘<PACKAGE_NAME>’;