looping error [message #410385] |
Fri, 26 June 2009 14:16  |
sant_new
Messages: 165 Registered: June 2008
|
Senior Member |
|
|
Hi all,
I get this error when running the below sql:
SQL> select lpad(' ',2*(level-1)) || mfnm
2 from mf
3 where mfnm not in
4 (select mfnm from mf_perm where user_group = 'breturn')
5 start with mn = 'sales'
6 connect by prior mfnm = mn
7 /
ORA-01436: CONNECT BY loop in user data
Doesnt look like we had this error when we were in older versions of oracle or its possible we didnt notice it then.
I did some research and found that the connect clause is doing some infinite looping, also read that its a bug.
Please give me your suggestions.
Thanks
|
|
|
|
|
|
|