BizTalk Server Orchestration - SQL Adapter Stored Procedure Call

Author

SQL Adapter Stored Procedure Call - Referencing Results

Wolfram1

2005-04-20, 2:57 am

I have an orchestration that calls a SP via the SQL Adapter using a field
from an inbound message as a parameter. The SP always returns a single row
with a single column. This works fine. I need to assign the returned data
to a variable but I cannot find the correct syntax to reference it within the
expression editor. Would be grateful for some help.

Scott Colestock

2005-04-20, 5:49 pm

When you get the message back from the sql adapter, use an expression shape
with the "xpath" function to extrac the value you want and assign it to a
variable, as in somevar = xpath(myMessage,"/somepath/somevalue");

Scott Colestock
www.traceofthought.net

"Wolfram1" wrote:

> I have an orchestration that calls a SP via the SQL Adapter using a field
> from an inbound message as a parameter. The SP always returns a single row
> with a single column. This works fine. I need to assign the returned data
> to a variable but I cannot find the correct syntax to reference it within the
> expression editor. Would be grateful for some help.