find_err.sql for finding errors from dba_errors.

set lines 120 pages 200

col line format 9999

col position format 999

col text format a80

select line, position, text from dba_errors

where owner= upper(‘&owner_name’)

and name = upper(‘&obj_name’)

order by SEQUENCE;