--pl/sql自定义异常
create or replace procedure update_sal(emp_no_in in emp.empno%type)
is
--定义一个异常
myex exception;
begin
update emp set sal = sal +1000 where empno=emp_no_in;
--sql%notfound表示没有update
--raise myex;触发myex
if sql%notfound then
raise myex;
end if;
exception
when myex then
dbms_output.put_line('pl/sql自定义异常catch');
end;
create or replace procedure update_sal(emp_no_in in emp.empno%type)
is
--定义一个异常
myex exception;
begin
update emp set sal = sal +1000 where empno=emp_no_in;
--sql%notfound表示没有update
--raise myex;触发myex
if sql%notfound then
raise myex;
end if;
exception
when myex then
dbms_output.put_line('pl/sql自定义异常catch');
end;