I am processing cursor rows in a FOR loop. I do a "SELECT INTO" from another table to see if I find a match on one of my cursor record items. If I find no matches, I do further processing (WHEN NO_DATA_FOUND THEN....); I may also find MORE than one match (TOO_MANY_ROWS). If I do, or if I find ONE matching row, I need to do further processing on either the one or all of the other ones. My question is, is TOO_MANY_ROWS actually an error and it doesn't return all the rows, or can I use it to process all of them? If it doesn't return them all, then do I need another cursor to handle the possible multiples? If so, when I declare the 2nd cursor will I have problems if the WHERE clause references
an item from the first cursor?
Any help is appreciated.