SET LINESIZE 2000

SET PAGESIZE 0

SET VERIFY OFF

SET FEEDBACK OFF

@&1

SELECT 'Filename: &1' FROM DUAL;

SELECT '(' || TYPE || ' ' || NAME || '/0:' || POSITION || ')' || ' ' || LINE || ':' || POSITION || ' ' || TEXT as ERRORS

FROM ALL_ERRORS

WHERE line <> 0

AND (

TYPE || ' ' || OWNER || '.' || NAME in (&2)

OR

(OWNER = USER AND TYPE || ' ' || NAME in (&2))

)

ORDER BY NAME, TYPE, SEQUENCE;

exit