An exception is usually an error message. You are not supposed to write any code/process there. If WHEN TOO_MANY_ROWS is something expected, you may have to put it as a condition in the BEGIN select... part.
2010/5/24 Manju <reach0...@gmail.com> > Hi Team, > > I need help in the below structure of PL/SQL block asap. Is this good > to do? or any better way to handle the same. > > BEGIN > select... > EXCEPTION > WHEN TOO_MANY_ROWS THEN > BEGIN > select ... > EXCEPTION > WHEN TOO_MANY_ROWS THEN > BEGIN > select ... > EXCEPTION > WHEN TOO_MANY_ROWS THEN > ---handle here > WHEN NO_ROWS_FOUND THEN > RAISE; > END > WHEN NO_ROWS_FOUND THEN > RAISE; > END > WHEN NO_ROWS_FOUND THEN > ---handle here > WHEN OTHERS THEN > ---handle here > END > > Thanks! > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
