none
WCF Oracle Adaptor RRS feed

  • Question

  • Is is possible to concatinate data from mulitple tables in oracle into a single message ?
    • Edited by sbonello Tuesday, August 4, 2009 12:07 PM
    Monday, August 3, 2009 2:52 PM

Answers

  • If you want to use polling, you can write your select query to select from multiple tables. e.g.:

    select column_names from table1, table2, table3.

    Such select queries can be used with polling.

    Tuesday, August 4, 2009 12:50 PM

All replies

  • yes you can
    KiranMP
    Monday, August 3, 2009 2:56 PM
  • The problem that i am finding is to how to set a correlation between the three messages in the seqential convoy.
    Tuesday, August 4, 2009 10:43 AM
  • can you elaborate on this, what do you want to do and what problem you are facing.
    KiranMP
    Tuesday, August 4, 2009 11:50 AM
  • From biztalk I need to connect to an oracle database and pull data from three different tables. I then need to concatinate the message into a single message and send the resulting message to a web service.

    I am using the polling mechanism (using the wcf oracle adaptor) to get the data from the three different tables. The problem that I am facing is how to construct the orchestration to perform three different polling receive port and concatinate the messages into a single message.

    Tuesday, August 4, 2009 11:59 AM
  • If you want to use polling, you can write your select query to select from multiple tables. e.g.:

    select column_names from table1, table2, table3.

    Such select queries can be used with polling.

    Tuesday, August 4, 2009 12:50 PM