oracle db - how to identify compilation errors

1.

select * from user_errors;

2.

SELECT RTRIM(INITCAP(e.type))||' '||e.name||': Line '||
      TO_CHAR(e.line)||' Column '||TO_CHAR(e.position) linecol,
      s.text sourceline,RPAD(' ',(e.position - 1))||'^' errpos,
      e.text error
FROM   user_source s,user_errors e
WHERE  e.type = s.type
AND    e.name = s.name
AND    e.line = s.line
ORDER BY e.name,e.sequence

The latter one will give you the exact line where the error occcurs