Empty columns are missing in data received using inbound operation RRS feed

  • Question

  • Dear All,

    I have an issue while polling oracle stored procedure from biztalk server 2010.

    The stored procedure returns a data set contains 10 columns. The schema is generated without any issue. The issue comes after deploying the application. The polled data only contains only NON EMPTY columns. In other words, if the fifth column do not have any data, then the fifth column is missing in the result it contains only nine columns.

    This leads to a mismatch in the schema definition and incomming message.

    For example, if the column 'remarks' is empty, then I expect <remarks/> in the incomming message. But while polling, the element <remarks/> is missing

    I am using WCF-OracleDB adapter with Biztalk server 2010 and oracle 11g.

    Am I missing any setting ?

    Thanks in advance

    Thursday, July 11, 2013 5:51 AM