ganapathy,

SP2 is going to have to do SOMETHING to communicate with SP1.

If SP1 is dependant upon the successful completion of SP2 in order to continue, you need to:

1) Use an OUTPUT parameter in SP2 to return the success/failure status, OR

2) Use the RETURN statement in SP2 to return the success/failure status, OR

3) Use a table or some other means to convey the success/failure.

Naturally after calling SP2, SP1 should check SP2's success/failure before continuing execution.

Wayne