Answered by:
How to perform a SELECT operation on 2 Tables using WCF-ORACLE DB Adapter? Can it be done?

Question
-
How to perform a SELECT operation on 2 Tables using WCF-ORACLE DB Adapter? Can it be done?
Racha Rams
Sunday, July 9, 2017 9:12 PM
Answers
-
Please elaborate: Short description of what you want to do/have
I assume table view or xmltype view is not what you need?
/Peter
- Proposed as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:54 AM
- Marked as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:54 AM
Sunday, July 9, 2017 9:38 PM -
Hi,
My advice would be to use a stored procedure rather than multi-joins across tables (not sure if it is even possible to do an inner join across multiple tables).
You can refer to the links below:
https://msdn.microsoft.com/en-us/library/dd788064.aspx
https://seroter.wordpress.com/biztalk-and-wcf-part-viii-biztalk-adapter-pack-service-model-patterns/ (Scenario #2 – Consuming Oracle Stored Procedures)
Rachit Sikroria (Microsoft Azure MVP)
- Proposed as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:53 AM
- Marked as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:54 AM
Sunday, July 9, 2017 11:41 PMModerator
All replies
-
Please elaborate: Short description of what you want to do/have
I assume table view or xmltype view is not what you need?
/Peter
- Proposed as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:54 AM
- Marked as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:54 AM
Sunday, July 9, 2017 9:38 PM -
Hi,
My advice would be to use a stored procedure rather than multi-joins across tables (not sure if it is even possible to do an inner join across multiple tables).
You can refer to the links below:
https://msdn.microsoft.com/en-us/library/dd788064.aspx
https://seroter.wordpress.com/biztalk-and-wcf-part-viii-biztalk-adapter-pack-service-model-patterns/ (Scenario #2 – Consuming Oracle Stored Procedures)
Rachit Sikroria (Microsoft Azure MVP)
- Proposed as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:53 AM
- Marked as answer by Rachit SikroriaModerator Saturday, July 22, 2017 9:54 AM
Sunday, July 9, 2017 11:41 PMModerator -
Peter's right... what is stopping you from defining a view with the query and then using the view in the query using the WCF-ORACLE DB adapter ?
Regards.
Monday, July 10, 2017 4:44 AM -
Hi ,
You can simply create a stored procedure and call that stored procedure within your biztalk solutions .There are multiple articles exists on web to guide you .
one of the link is here http://synthesisconsulting.net/blog/2012/5/13/oracle-and-biztalk-server-part-2.html
If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply
Monday, July 10, 2017 9:38 AM