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

Answer 1

Please elaborate: Short description of what you want to do/have

I assume table view or xmltype view is not what you need?

/Peter

Answer 2

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)

Answer 3

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.

Answer 4

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