COMPILE all PROCEDURE

SELECT DISTINCT 'ALTER PROCEDURE '||NAME||' COMPILE ;'
FROM USER_SOURCE
WHERE TYPE='PROCEDURE'


ALTER PROCEDURE ARTICODRACHV COMPILE ;

SET PAGESIZE 100

DESC USER_SOURCE;