系统异常
DECLARE
test varchar2(10);
BEGIN
select name INTO test from dept where id='33';
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('没有数据');
END;
/
自定义异常
DECLARE
tname varchar2(10);
e exception;
BEGIN
SELECT name into tname from dept where id='01';
IF tname<>'B部门' THEN
RAISE e;
END IF;
DBMS_OUTPUT.PUT_LINE(tname);
EXCEPTION
WHERE e THEN
DBMS_OUTPUT.PUT_LINE('错误的部门');
END;
/