oracle递归查询报错

SELECT *
FROM T_OrgCom t
where t.systemcode = '04' and t.ENABLED = '1'
START WITH t.id='00000000'
CONNECT BY   PRIOR t.ID=t.pid
报错：用户数据中的connect by 循环


SELECT *
FROM T_OrgCom t
where t.systemcode = '04' and t.ENABLED = '1'
START WITH t.id='00000000'
CONNECT BY NOCYCLE  PRIOR t.ID=t.pid
添加NOCYCLE
NOCYCLE  不产生循环