mother_sotred_proc()
begin
CALL child_sotred_proc();
end;
--------------------------
child_sotred_proc()
begin
# i want to exit from here in such way so that mother_sotred_proc stop working or exist;
end;
The motto is that if any exception found in child SP then immediately controller should stop working totally and will exit from mother SP and will throw a message.