Resources for IT Professionals >
Forums Home
>
BizTalk Server Forums
>
BizTalk Server Adapters and Adapter Pack
>
How to provide multiple input parameters for where clause in SQLEXECUTE
How to provide multiple input parameters for where clause in SQLEXECUTE
- I am using SQLEXECUTE in BizTalk. I would like to execute the query ... select * from ACCOUNT where ACCTID=:num1 or BALANCE=:num2; Could someone help me with the XML Syntax? I tried adding the XML to the post but it would not display properly. Thanks!
Answers
- <SQLEXECUTE xmlns="http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE">
<SQLSTATEMENT>select * from ACCOUNT where ACCTID=:num1 or BALANCE=:num2</SQLSTATEMENT>
<PARAMETERSCHEMA>num1 NUMBER, num2 NUMBER</PARAMETERSCHEMA>
<PARAMETERSET>
<PARAMETERDATA xmlns="http://Microsoft.LobServices.OracleDB/2007/03">
<PARAMETER xmlns:v="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<v:string>1001</v:string>
<v:string>5000</v:string>
</PARAMETER>
</PARAMETERDATA>
</PARAMETERSET>
</SQLEXECUTE>
Thanks!
Manas- Marked As Answer byColorado Mike Thursday, October 29, 2009 2:36 PM
- Proposed As Answer byManas Garg - MSFT Thursday, October 29, 2009 8:00 AM
All Replies
- <SQLEXECUTE xmlns="http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE">
<SQLSTATEMENT>select * from ACCOUNT where ACCTID=:num1 or BALANCE=:num2</SQLSTATEMENT>
<PARAMETERSCHEMA>num1 NUMBER, num2 NUMBER</PARAMETERSCHEMA>
<PARAMETERSET>
<PARAMETERDATA xmlns="http://Microsoft.LobServices.OracleDB/2007/03">
<PARAMETER xmlns:v="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<v:string>1001</v:string>
<v:string>5000</v:string>
</PARAMETER>
</PARAMETERDATA>
</PARAMETERSET>
</SQLEXECUTE>
Thanks!
Manas- Marked As Answer byColorado Mike Thursday, October 29, 2009 2:36 PM
- Proposed As Answer byManas Garg - MSFT Thursday, October 29, 2009 8:00 AM
- Thanks Manas - works great! Do you have any tips for using SQLEXEC that you could pass on?? Thanks again!
