触发器|存储过程 抛出异常——>oracle

raise_application_error:

create or replace trigger test_trigger
before insert or update or delete
on  test
begin
raise_application_error('-20002', 'you can not change the data !');
end;

create procedure myPro(mun int,outPam out  varchar2)

is

begin

select name from myTable where id = num into outPam;

Exception

raise_application_error('-20002', 'you can not change the data !');

end;