--해당 오브젝트 invalid 상태 확인 select owner, object_name, status from dba_objects where object_name = '해당펑션명' --연관 오브젝트 invalid 상태 확인 select owner, object_name, status from dba_objects where (owner,object_name) in ( select distinct owner, referenced_name from dba_dependencies start with name = '해당펑션명' connect by nocycle prior referenced_name = name and prior owner = owner )
의존성 체크 쿼리 만들어보았는데.. 잘 나올지 모르겠네요.
관련된 오브젝트가 invalid 된 것 없는지 확인해보세요.