Re: Stored procedure parameter order

Home Page Forums BizTalk 2004 – BizTalk 2010 Stored procedure parameter order Re: Stored procedure parameter order

#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.