|
Home > Archive > BizTalk Server General > March 2006 > multiple stored proc calls in one message
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
multiple stored proc calls in one message
|
|
| Eric Stott 2006-03-19, 11:59 am |
| I have a message that has multiple orders, each order has to be inserted
into the database via a stored proc. Is it possible to create 1 message that
has all of the orders from that message AND get back in one message the
result of each of the stored proc calls? When I create the multiple row
call, it executes fine, but I only get 1 result, the first one.
Is there a trick on how to get all of the results of the many stored proc
calls in one message from the sql adapter?
Thanks,
Eric
| |
|
| Hi Eric,
I don't think it's possible to have a batch insert using sql adapter, your
option is :
1. create a loop on orchestration and call your sql adapter, then aggregate
the response to one message
2. create a manage code in .net and pass your multiple order as a parameter
and let your manage code call the stored procedure.
Hope this help.
If you get another idea for this please let me know.
Regards,
Alex
"Eric Stott" wrote:
> I have a message that has multiple orders, each order has to be inserted
> into the database via a stored proc. Is it possible to create 1 message that
> has all of the orders from that message AND get back in one message the
> result of each of the stored proc calls? When I create the multiple row
> call, it executes fine, but I only get 1 result, the first one.
>
> Is there a trick on how to get all of the results of the many stored proc
> calls in one message from the sql adapter?
>
> Thanks,
> Eric
>
>
>
| |
| Eric Stott 2006-03-21, 3:09 am |
| I have gone down the #1 option already, but I was hoping that there was a
way to structure the stored proc, or some other way to get all of the
responses back in one message.
Thanks,
Eric
http://stottcreations.com/blog
"Alex" <Alex@discussions.microsoft.com> wrote in message
news:EE33761A-5470-4912-95E7-47E684FA82A2@microsoft.com...[vbcol=seagreen]
> Hi Eric,
>
> I don't think it's possible to have a batch insert using sql adapter, your
> option is :
>
> 1. create a loop on orchestration and call your sql adapter, then
> aggregate
> the response to one message
> 2. create a manage code in .net and pass your multiple order as a
> parameter
> and let your manage code call the stored procedure.
>
> Hope this help.
>
> If you get another idea for this please let me know.
>
> Regards,
>
> Alex
>
> "Eric Stott" wrote:
>
|
|
|
|
|