Re: Debatching messages from Oracle Adapter 3.0 – WCF generated Schema

Home Page Forums BizTalk 2004 – BizTalk 2010 Debatching messages from Oracle Adapter 3.0 – WCF generated Schema Re: Debatching messages from Oracle Adapter 3.0 – WCF generated Schema

#21679

I found a solution this afternoon. (my own question)

The generated schema doesn’t have a root reference set. Set this to POLLINGSTMT. Set to Envelope=yes.

I then deleted the POLLINGSTMTRECORD entry from the generated schema. I created a new schema named POLLINGSTMTRECORD, INCLUDED the original schema, named the root POLLING STMTRECORD and set it’s type to POLLINGSTMTRECORD from the generated schema. I set this new “record” to be the root node.

I could probably have just set the root to the original entry for POLLINGSTMTRECORD. I’m going to try this next.

I was able to successfully debatch 10 rows from oracle using this minor change for the oracle adapter.