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;