[ORACLE] Procedure Re-Compile

/* 오라클 프로시저 재 컴파일 방법 */

SELECT  'ALTER PROCEDURE '||OBJECT_NAME||' COMPILE;' DSQL
FROM    USER_PROCEDURES
WHERE   OBJECT_TYPE = 'PROCEDURE'
ORDER BY OBJECT_NAME
;

ALTER PROCEDURE [PROCEDURE NAME] COMPILE;