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问题 |
|