NO_DATA_FOUND

来源:互联网 发布:sql语句按降序排列 编辑:程序博客网 时间:2024/04/30 14:30

DECLARE
  L_ORDERID NUMBER;
  L_ITEMNO  NUMBER;
BEGIN
  BEGIN
    SELECT EXIT(NVL(ORDERID, 0), NVL(ITEMNO, 0) INTO L_ORDERID, L_ITEMNO FROM ORDERS WHERE ORDERID = 12345;
  EXCEPTION
    WHEN NO_DATA_FOUND THEN
      L_ORDERID := 0;
      L_ITEMNO  := 0;
  END;
END;