Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Stored procedure parameter order
- This topic has 4 replies, 2 voices, and was last updated 3 years, 5 months ago by community-content.
-
AuthorPosts
-
-
August 16, 2010 at 10:29 AM #25644
I’m building a BizTalk orchestration which calls a DB2 stored procedure. I’ve done this many times before and thought this one would be no different. However, it seems that BizTalk wants the stored procedure parameters in one order, and the DB2 side wants another.
The stored procedure parameters (as defined in the SP itself) are in this order: input (int), input (string), input (string), input (int), input (string), input (string), input (string), input/output (string), input (int), input (int), output (int), output (string).
The way BizTalk seems to like it is this: input (int), input (string), input (string), input (int), input (string), input (string), input (string), input (int), input (int), input/output (string), output (int), output (string).
When I arrange the parameters in my schema in the DB2 order, I get this error: The parameter value for parameter 7 could not be converted to a native data type. Parameter Name: <name>, Data Type: <string from input/ouput parameter>, Value : Int
If I arrange them in the BizTalk order, I get this error: THE VALUE OF INPUT HOST VARIABLE OR PARAMETER NUMBER 8 CANNOT BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE.
Is there something with how BizTalk handles INPUT/OUTPUT parameters, or parameter order in general that I’m missing? Or is it something completely obvious that I’ve overlooked?
Thanks!
-
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.
-
February 12, 2018 at 3:49 PM #37455Fluopophy
Its normally sophisticated to tell the person close to you to pass you the salt and not stand up and reach for it yourself across the table.If you are offering certain claims about your product, they must be true. Here you would not require incurring anything and still you would be able to reach upon massive audiences across the globe. At the identical process,heading for being the hair specialists are depending on how long a whole lot additional all around the planning to get the hair scissors to enhance the their experience fluctuate widely. Johnson Online and see how for the first time in the history of the UFC, referree Mario Yamasaki and his brother Fernando will be refereeing on the same card. In mediation, a neutral accountant, child psychologists or educational consultant can help inform and educate spouses based on their experience or information gathered independently by interviewing children privately, reviewing tax and employment records or reviewing research on specific points of interest and concern.Do not use AJAX and Flash too often. In mediation, a neutral accountant, Cheap Jerseys China Wholesale, child psychologists or educational consultant can help inform and educate spouses based on their experience or information gathered independently by interviewing children privately,Wholesale NFL Jerseys, reviewing tax and employment records or reviewing research on specific points of interest and concern.Wholesale Jerseys China. Often visual appearance for strategies towards provide your clientele and in direction of include accurate truly worth toward them and their office. They should be able to schedule service calls at your earliest convenience. In 1978, IWC launched the world’s initially titanium view situation and bracelet.Sponsoring your local young professionals association can align your carpet cleaning service business’ brand with a carpet cleaning agency whose members will influence and shape the future of your community and your local customer base.<br>Visit my sitehttp://www.cheapnfljerseysdiscount.us.com/
-
November 9, 2020 at 3:58 PM #49579biztalkgurus
Pumpkinheads ~ Rainbow Rowell ~ 9781250312853
-
November 9, 2020 at 6:40 PM #49590biztalkgurus
The Prettiest by Brigit Young – 9781626729230
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.