title: Getting error as "ORA-32044: cycle detected while executing recursive WITH query"
body: <p>I am getting error as</p>
  <blockquote>
  <p>ORA-32044: cycle detected while executing recursive WITH query</p>
  </blockquote>
  <p>while executing the following query in Oracle.</p>
  <pre><code>WITH EmpsCTE (affiliation_id, from_customer_id,to_customer_id, to_name, level1)
  AS
  (
  SELECT affiliation_id, from_customer_id,to_customer_id, to_name, 0
   FROM affiliation aff
   WHERE to_customer_id != from_customer_id
   and to_customer_id = 1000022560394
  UNION ALL
  SELECT aff.affiliation_id, aff.from_customer_id,aff.to_customer_id, aff.to_name, m.level1 + 1
   FROM affiliation aff
   INNER JOIN EmpsCTE  m
   ON aff.to_customer_id = m.from_customer_id
  )
  SELECT * FROM EmpsCTE;
  </code></pre>