Write a trigger like this:
create or replace
trigger <triggername>
before update on <tablename>
for each row
declare
isexception number := 0;
begin
begin
<sql statements that may cause exception>
exception
when others then
isexception := 1;
end;
end;
An example of a procedure where execution continues after DIVISION BY ZERO since exception is handled in inner block
create or replace
procedure testexcept
as
i number := 0;
five constant number := 5;
begin
for i in 1 .. 10
loop
begin
dbms_output.put_line('5 / (' || i || ' - 5) ' || five / (i - five));
exception
when others then
dbms_output.put_line('inner exeption - divide by zero error!!');
end;
end loop;
end testexcept
;