IF IN_DN_NUMBER IS NOT NULL THEN SELECT COUNT(*) INTO V_HAS FROM SALEFROMSTORE WHERE ORDERID = IN_DN_NUMBER; IF V_HAS = 0 THEN OU_RETURN := 'ERROR'; OU_MSG := '您保存的交货单已经不存在,请确认后再保存!'; RETURN; --EXIT; 这个是不返回直接退出 END IF; END IF;
IF IN_DN_NUMBER IS NOT NULL THEN SELECT COUNT(*) INTO V_HAS FROM SALEFROMSTORE WHERE ORDERID = IN_DN_NUMBER; IF V_HAS = 0 THEN OU_RETURN := 'ERROR'; OU_MSG := '您保存的交货单已经不存在,请确认后再保存!'; RETURN; --EXIT; 这个是不返回直接退出 END IF; END IF;