Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Stored procedure parameter order › Re: Stored procedure parameter order
August 16, 2010 at 12:04 PM
#25646
Hi,
One I was working at one of my customer’s site – I saw such an error:
This was happening in a case if one of parameters of incoming message wwas empty (is I remember correct) or null, the SQL statement which should be executed – was “shortening”. i.e. the parameter is null = the field didn’t appear in message sent to DB2.
The solution to problem was scripting functoid: if field in incoming message is empty – pass to outgoing message empty string or default value.