Click here to Skip to main content
12,694,842 members (35,246 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


1 bookmarked

Executing Stored Procedure using BizTalk Oracle Adapter

, 19 May 2009 CPOL
Rate this:
Please Sign up or sign in to vote.
Executing Stored Procedure using BizTalk Oracle Adapter

Stored procedures from the Oracle adapter can only be called when they are within a package, this is due to the Oracle driver that does not provide the list of parameters. Visit Microsoft MSDN to read more about Oracle adapter calling the stored procedure.

Limitations of Oracle adapter calling a stored procedure wrapped in a package

For procedures, large-object (LOB) types are supported as IN parameters only. When they appear as INOUT, RETURN and OUT, the procedure is not displayed in the browser and therefore is not callable. LOBs are supported in tables in the Insert, Update, or Query methods.

In this article, we will assume the package containing the procedure are stored procedures. In order to call a stored procedure wrapped up in a package, generate the metadata of the stored procedure as shown below:


The schema containing all the types of the package, port type and multi-part message will be generated. In order to construct the request message, select the root-reference property of the schema generated to the desired Request Message. Construct the message in a message assignment shape by loading the XML into an XMLDocument variable. The oracle adapter creates request, response and exception type messages and schema. Create a new solicit request-response port in the orchestration and select the exiting port created in the orchestration as below:


technorati tags :


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Qatar Qatar
I am a BizTalk Server MVP for 2010 and an active blogger and a participant on the MSDN BizTalk Server Forums. I am currently working as a BizTalk Architect at a Bank in Qatar. Before this position I worked as a Sharepoint Consultant in UAE , BizTalk Architect in Bank Saudi Fransi in Saudi Arabia and United Bank Ltd in Pakistan.

I also achieved MCTS certification in BizTalk Application development in June 2008.

Click here to check out my Blog.

SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter.

Envelope Wrapper.

Aggregator (Sequential Convoy)

Splitter (Debatching multiple records)
Recipient List
Scatter and Gather using Self Correlating Port

You may also be interested in...

Comments and Discussions

-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170118.1 | Last Updated 19 May 2009
Article Copyright 2009 by Abdul_Rafay
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid