SELECT INTO Returning 1 row
448221Mar 30 2006 — edited Mar 30 2006Usually if I have a SELECT INTO, I would catch the NO_DATA_FOUND/ TOO_MANY_ROWS exceptions to ensure there is only 1 row returned. However, from my java experience, catching exception as a way to handle normal processing logic is not a good programming practice. Is it also true for PLSQL?
If yes, how should we change our code without using exception. I can handle too_many_rows by adding the ROWNUM=1 condition to my SELECT. But how about NO_DATA_FOUND?
Thx