CREATE OR REPLACE FUNCTION
devision(dividend IN NUMBER,divisor IN NUMBER)
RETURN NUMBER IS
re NUMBER;
e_divisor_0 exception;
BEGIN
if divisor=0 then
raise e_divisor_0;
end if;
re := dividend/divisor;
RETURN re;
EXCEPTION
WHEN e_divisor_0 THEN
DBMS_OUTPUT.PUT_LINE('ERROR!');
END;
/
exception后面的只能跟异常类型
devision(dividend IN NUMBER,divisor IN NUMBER)
RETURN NUMBER IS
re NUMBER;
e_divisor_0 exception;
BEGIN
if divisor=0 then
raise e_divisor_0;
end if;
re := dividend/divisor;
RETURN re;
EXCEPTION
WHEN e_divisor_0 THEN
DBMS_OUTPUT.PUT_LINE('ERROR!');
END;
/
exception后面的只能跟异常类型
DBMS_OUTPUT.PUT_LINE('ERROR!');
没有定义的异常都可以用others捕捉到