testing an overloaded function

Two functions return the results of a COUNT (*) from a select statement. One function uses a customer id, another uses a customer first name and last name.

If there were more than one customers with the same first_name and last_name, what is the better way to return a NULL?

  exception
when too_many_rows

   then
return null; ?

or use

IF COUNT (*) >1 .....RETURN NULL; (at the appropriate place in the syntax) ?

or, is either one good to use? Received on Thu Dec 06 2001 - 14:07:34 CST