In the On-ERROR trigger write:-
al_id Alert;
al_button Number;
BEGIN
if errcode=40208 then
--do nothing;
else
al_button := Show_Alert( 'Error_Alert' );
RAISE FORM_TRIGGER_fAILURE;
end if;
end;
al_id Alert;
al_button Number;
BEGIN
if errcode=40208 then
--do nothing;
else
al_button := Show_Alert( 'Error_Alert' );
RAISE FORM_TRIGGER_fAILURE;
end if;
end;
No comments:
Post a Comment