NO_DATA_FOUND问题

select nvl(max(memberid),0) into v_id from zibeilist where surnameid=v_surnameid;

BEGIN
  select memberid into v_id from zibeilist where surnameid=v_surnameid;     <-----     这句报NO_DATA_FOUND错误
  EXCEPTION
     WHEN NO_DATA_FOUND THEN
        NULL; -- 捕获错误不执行
  END;


以上两种方法都可以解决NO_DATA_FOUND问题