create or replace procedure USER_RECOMPILE_PROCEDURE is
begin
for tempCursor in (
select object_name
from user_objects
where object_type = 'PROCEDURE'
and status = 'INVALID'
) loop
execute immediate 'ALTER PROCEDURE ' ||
tempCursor.Object_Name || ' compile';
end loop;
end USER_RECOMPILE_PROCEDURE;
/
exec USER_RECOMPILE_PROCEDURE;
沒有留言:
張貼留言