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.databasejournal.com/news/article.php/3656076
