Hierarchical queries sometimes fail because the data contain rows that reference each other: a loop. Oracle 10g has syntax and two new pseudocolumns to aid in finding such loops.

This story continues at
http://www.dbasupport.com/oracle/new...ocolumns.shtml