储存过程入门04--异常

系统异常

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;
/