用ODAC 执行下面的SQL出现 "ORA-01436: CONNECT BY loop in user data"的错误啊 ( 积分: 1

用ODAC 执行下面的SQL出现 &quot;ORA-01436: CONNECT BY loop in user data&quot;的错误啊 ( 积分: 100 )<br />用ODAC&nbsp;执行下面的SQL出现&nbsp;&quot;ORA-01436:&nbsp;CONNECT&nbsp;BY&nbsp;loop&nbsp;in&nbsp;user&nbsp;data&quot;的错误啊。<br>但是在另外的ORACLE的工具或者是ADO是不会报错的。<br>SQL：<br>SELECT&nbsp;AID,ANAME,PARENT_ID,LEVEL&nbsp;FROM&nbsp;(&nbsp;&nbsp;SELECT&nbsp;DISTINCT&nbsp;TO_CHAR(ITEM_ID)&nbsp;AID&nbsp;,TRIM(ITEM_NAME)&nbsp;ANAME,&nbsp;TO_CHAR(PARENT_ITEM_ID)&nbsp;PARENT_ID&nbsp;FROM&nbsp;RPT_ITEM&nbsp;&nbsp;WHERE&nbsp;ITEM_ID&nbsp;NOT&nbsp;IN&nbsp;(SELECT&nbsp;DISTINCT&nbsp;ITEM_ID&nbsp;FROM&nbsp;RPT_REPORT_ITEM&nbsp;&nbsp;WHERE&nbsp;REPORT_ID=1004&nbsp&nbsp&nbsp;CONNECT&nbsp;BY&nbsp;PRIOR&nbsp;AID=PARENT_ID&nbsp;START&nbsp;WITH&nbsp;LEVEL&nbsp;＝&nbsp;1<br><br>请大家帮帮，谢谢

错误不是很明显吗？&nbsp;你的connect&nbsp;By&nbsp;出现了前后循环了，检查一下你的数据，其它的不抱错，可能没执行到循环的一行。