SQL Adapter with Request-Response port and Store Procedure

[rpc3]

I'm having trouble with this scenario. The stored procedure (SP) does not seem to be reading my input argument, because when I use the input argument in the WHEN of the stored procedure, I get nothing in the resulting message. I can get a list of records back if I hard code (in the SP) the input variable that I'm attempting to send into the SP.

Can anyone help me diagnose?

Thanks,
Paul

 

[rpc3]

With the help of an in-house SQL Server user, I was able to find out that the declared type for my input argument was incorrect. I had declared it to be type varchar - not knowing the proper variable type information for SQL Server. So, when I declared the argument as "nvarchar(15)" - the same type as the column in the database table - the SP started working properly.

Let this be a lesson to you, too! JK

Paul