If you are only concerned with the top most parent of a given item, I might look at doing it a different way.
Have you considered using CONNECT BY PRIOR to get the full list in one select statement, sorting it and taking only the item where there parent id is NULL? That would leave you one iteration of the outer cursor. Then call the second cursor for the list of assembly level statuses. It would remove the requirement for the recursive call, which I still believe to be the root of the problem (recursion is fine, but as sonty stated more clearly, you do not appear to have an exit, so you are just repeatedly opening the ass_cur until the OPEN_CURSORS parameter explodes. Just a thought. -AT. On Jan 26, 5:32 am, Chris <[email protected]> wrote: > open_cursors paramater has been changed to 3000 and am still getting > this error. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
