Goodmorning, I've a small problem with my query always get an ORA-01436 CONNECT BY Loop in user data error. I try to create a Tree , I need it in a Report.

Table T_COM_OBJ:

OBJ_ID (PK)
OBJ_NAME
OBJ_DESCRI
OBJ_COMMENT
OBJ_PARENT (FK required with OBJ_ID)

The Query I try to run is this one.

SELECT LEVEL,LPAD(' ',8*(LEVEL-1))||T_COM_OBJ.OBJ_NAME, T_COM_OBJ.OBJ_PARENT, T_COM_OBJ.OBJ_ID
FROM VDR.T_COM_OBJ
START WITH T_COM_OBJ.OBJ_ID in (select obj_id obj_main from vdr.t_com_obj where obj_id=obj_parent)
CONNECT BY PRIOR T_COM_OBJ.OBJ_ID = T_COM_OBJ.OBJ_PARENT

I get some result but then he stops and returns me the error.
So if someone has an idee just reply.

Thx.