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;