Home » SQL & PL/SQL » SQL & PL/SQL » Heirarchical Query, Connect By Loop in User Data
Heirarchical Query, Connect By Loop in User Data [message #398410] Thu, 16 April 2009 03:19 Go to next message
benseer
Messages: 22
Registered: October 2005
Location: Bangalore
Junior Member
Hi,

Is there any method to find the node which has problem in heirachical query.

As my data is complex and has levels upto 10 , its not possbile to fix manually. I have idendtified the series "START WITH" ,which causing problem. But I couldnt find the exact nodes in the seris which creates the loop.

Even exception handling not working in that.

Please advice.

Regards,
Benz
Re: Heirarchical Query, Connect By Loop in User Data [message #398922 is a reply to message #398410] Sun, 19 April 2009 15:55 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
Search the documentation for "nocycle" and "connect_by_iscycle".
Re: Heirarchical Query, Connect By Loop in User Data [message #399001 is a reply to message #398922] Mon, 20 April 2009 04:18 Go to previous message
benseer
Messages: 22
Registered: October 2005
Location: Bangalore
Junior Member
Thanks Barbara,

This helped me to skip the connect by Loop error.
Previous Topic: what's wrong with this query
Next Topic: Merge join cartesian
Goto Forum:
  


Current Time: Sat Dec 10 16:52:49 CST 2016

Total time taken to generate the page: 0.07841 seconds