오라클 테이블 컬럼 추가 후 INVALID OBJECT 컴파일

1. FUNCTION 컴파일

SELECT 'ALTER FUNCTION '||OWNER||'.'||NAME||' COMPILE;' FROM DBA_SOURCE

WHERE OWNER = 'SCOTT' AND TEXT_LIKE '%TABLE_NAME%'

AND TYPE = 'FUNCTION'

GROUP BY OWNER, NAME, TYPE

ORDER BY TYPE, NAME;

2. PROCEDURE 컴파일

SELECT 'ALTER PROCEDURE '||OWNER||'.'||NAME||' COMPILE;' FROM DBA_SOURCE

WHERE OWNER = 'SCOTT' AND TEXT_LIKE '%TABLE_NAME%'

AND TYPE = 'PROCEDURE'

GROUP BY OWNER, NAME, TYPE

ORDER BY TYPE, NAME;

3. TRIGGER 컴파일

SELECT 'ALTER TRIGGER '||OWNER||'.'||NAME||' COMPILE;' FROM DBA_SOURCE

WHERE OWNER = 'SCOTT' AND TEXT_LIKE '%TABLE_NAME%'

AND TYPE = 'TRIGGER'

GROUP BY OWNER, NAME, TYPE

ORDER BY TYPE, NAME;