Hi All,
I have a package to run all the procedures.

Basically, all the procedure performing the DML command.
For instance, I have package as follow.

PACKAGE test IS
procedure A;
procedure B;
procedure C;
procedure D;
function run_all return boolean;
END;

PACKAGE BODY test IS
procedure a is
begin
insert into ....
WHEN OTHERS THEN
....

end;

procedure b is
begin
delete into ....
WHEN OTHERS THEN
....

end;

procedure C is
begin
update into ....
WHEN OTHERS THEN
....
end;

procedure d is
begin
insert into ....
WHEN OTHERS THEN
....

end;

function run_all return boolean is
begin
a;
b;
c;
d;
end;

Question : how to ask the program to exit if there is error on b without continuing the procedure c and d ? must I have a check for every single procedure ?


Thanks