Click here to Skip to main content
15,861,125 members
Articles / All Topics

Executing Stored Procedure using BizTalk Oracle Adapter

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
19 May 2009CPOL1 min read 21.1K   1  
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:

metadata

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:

Oracle_SP_port


technorati tags :
This article was originally posted at http://abdulrafaysbiztalk.wordpress.com?p=140

License

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


Written By
Architect
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)
Resequencer
Recipient List
Scatter and Gather using Self Correlating Port

Comments and Discussions

 
-- There are no messages in this forum --