You Asked
Hi Tom,
I have created 3 stored procedures, I need to run the stored procedure in such a way when the activities of 1st stored procedure completed then run 2nd, only when the activities of 2nd stored procedure completed then only run the 3rd. Please help me to manage the procedure.
Thanks,
Gyan
and Connor said...
Sorry - is there any reason you cannot do just:
begin
proc1;
proc2;
proc3;
end;
or is there something else in this requirement you have not revealed to us ?
Is this answer out of date? If it is, please let us know via a Comment