RunSQL.sql

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