Home » SQL & PL/SQL » SQL & PL/SQL » looping error (10.2.0.4, windows 2003)
looping error [message #410385] Fri, 26 June 2009 14:16 Go to next message
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
Re: looping error [message #410387 is a reply to message #410385] Fri, 26 June 2009 14:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
What is your database version?
Post DDL and DML.

[EDIT: I didn't notice that the version is 10.2.0.4, which is in the title.]
By
Vamsi

[Updated on: Fri, 26 June 2009 14:30]

Report message to a moderator

Re: looping error [message #410388 is a reply to message #410385] Fri, 26 June 2009 14:30 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Doesnt look like we had this error when we were in older versions of oracle or its possible we didnt notice it then.
or the data has changed.
Re: looping error [message #410393 is a reply to message #410385] Fri, 26 June 2009 15:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: looping error [message #410486 is a reply to message #410385] Sat, 27 June 2009 06:02 Go to previous message
srraajesh
Messages: 63
Registered: May 2005
Member
Here is a beautiful link that explains what this problem is and how to go about when it is encountered.

http://thinktibits.blogspot.com/2008/07/so-what-is-problem-i-got-error-ora.html

Previous Topic: analytical functions
Next Topic: ORA-12546 : TNS:permission denied (merged 2)
Goto Forum:
  


Current Time: Sat Dec 03 06:10:07 CST 2016

Total time taken to generate the page: 0.05116 seconds