ORA-01436 error

0 pts.
Tags:
Oracle 9i
We are trying to use connect by ..prior feature of oracle. Having said that we had used this type of queries and now we are facing this loop error for connect by prior. Any suggestions.
ASKED: May 26, 2004  3:59 PM
UPDATED: June 1, 2004  1:40 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

ORA-01436 occurs when a row is an descendant of itself (which is what “loop” means in this context). Usually, this means a mistake in your data.

It is possible to have loops in your data, but to do a hierarchical query on a subset of the data, as long as that subset does not contain any loops. If this is the case, reply with details of what your data is, exactly what you are trying to do, and the code that is producing the error.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • PRASAD55
    We had solved this problem. Many thanks to all those replied.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following