declare
p number;
begin
p := 1/0;
exception
when zero_divide then dbms_output.put_line('1:0不能做分母');
dbms_output.put_line('2:0不能做分母');
when value_error then dbms_output.put_line('算数或转换错误');
end;
--zero_divide 0不能做分母
--value_error 算数异常
自定义例外
declare
cursor cc(var test_procedure.name%type) is select * from test_procedure t where t.job = var;
temp test_procedure%rowtype;
--自定义例外
no_emp_found exception;
begin
open cc('XX天');
fetch cc into temp;
if cc%notfound then
--抛出例外
raise no_emp_found;
end if;
close cc;
exception
when no_emp_found
then dbms_output.put_line('查无此人');
when others
then dbms_output.put_line('其他例外');
end;