How to use SQL adapter if the calling sp has an OUTPUT parameter

ALL,

I would like to insert some records into a SQL database table by using the

BizTalk SQL adapter.  The insert store procedure is already existed.  
However, I don’t know how to make it work because the calling convention
has 
an OUTPUT parameter @[EMAIL PROTECTED]
  in it.  

CREATE PROC myInsertProc
	 	 @[EMAIL PROTECTED]
(20)
	 	 @[EMAIL PROTECTED]
(20)
		,@[EMAIL PROTECTED]
(255)	OUTPUT

The purpose of the output parameter is to tell the caller if there is an 
error in the calling process.  The insert store procedure also returns a 
return code like this:

	DECLARE  @[EMAIL PROTECTED]
   @[EMAIL PROTECTED]
 = @[EMAIL PROTECTED]
 	@[EMAIL PROTECTED]
 to capture both the output error message and the return code with 
BizTalk SQL adapter?  

Lastly, how to handle exceptions throwing from the store procedure
(error)?  
I can’t find a sample to cover these situations.  

Do you have a sample?

Could you please help?

Thanks so much.

Abel Chan