CREATE OR REPLACE PROCEDURE "SP_MKOUVAL" ( v_metid in number,v_valuetype IN NUMBER,v_mettime IN DATE) as ..... form_trigger_failure EXCEPTION; begin ..... if a>b then raise form_trigger_failure; end if ..... EXCEPTION WHEN form_trigger_failure THEN ...... end;
as
.....
form_trigger_failure EXCEPTION;
begin
.....
if a>b then
raise form_trigger_failure;
end if
.....
EXCEPTION
WHEN form_trigger_failure THEN
......
end;