Oracle编译package body时遇到ORA-01775: looping chain of synonyms错误

如果package本身没有出现loop，则是它的依赖中有loop，查找依赖：

SELECT referenced_owner synonym_owner, referenced_name synonym_name 
FROM all_dependencies d
WHERE d.owner = 'owner'
  AND d.name = 'package_name'
  AND d.type = 'PACKAGE BODY'
  AND d.referenced_type = 'SYNONYM'

挨个消除依赖中存在的loop即可。