1.OBJ_ID and OBJ_PARENT should not have the same value in one record !
2. wrong pairs:
OBJ_ID OBJ_PARENT
1 1
1 2
2 1
SELECT obj_id, obj_parent from table_a
connect by prior obj_id = obj_parent;
ERROR:
ORA-01436: CONNECT BY loop in user data
[Edited by Ao on 10-02-2002 at 05:59 AM]
Reply With Quote