preventing CONNECT BY from generating an error if cycles exist

Hello;

  I am wondering if anyone knows of a way to issue the CONNECT BY clause on data that contains cycles? I have a business requirement that specifies that cycles could be present in the data and cannot be prevented. I want to use the CONNECT BY clause to prevent sending massive IN clauses, but I cannot because CONNECT BY will generate an error. Is there a similar clause that I can use besides CONNECT BY?

Any help would be appreciated.

Sincerely,

paul_at_paulrowe.com Received on Fri Aug 01 2003 - 10:44:11 CDT