Enveloping / Debatching with Oracle WCF - OracleDBBinding Polling Schema RRS feed

  • Question

  • I'm using the Adapter Pack 3.0 based Oracle Polling solution. When I query my table, I get approximately 10 rows. I'm only processing one record.

    I know I need to Debatch, but I'm having heck with the adapter generated schema. Does anyone have experience with this and/or an example of how to accomplish it.

    I've tried modifying the generated schema to be an envelope, without success. I'm sure I'm just missing something

    Tuesday, February 10, 2009 5:24 PM


All replies

  • This would be very helpful:

    Please mark answers that solve your problem.
    Wednesday, February 11, 2009 3:42 PM
  • I did finally get this working. The solution I found is on the biztalk guru forum:

    If anyone finds a better / easier way... PLEASE update me :)
    Wednesday, February 11, 2009 3:52 PM
  • Hi Matthew,

    Please can you list out the steps , As I am facing the similar issue.
    Oracle WCF adapter generated two schemas.


    Package name schema hierarchy.

    < Schema>

    ---à StoredProcedurename

    ---à StoredProcedurenameResponse


                  --à     Ns3:P_RESULT_SETRECORD

                                --à   Elements


    StoredProcedure name schema hierarchy.

    < Schema>


             --à   Elements

    ---à Arrayof P_RESULT_SETRECORD

              -à  P_RESULT_SETRECORD

                        à   Elements


    Please can you let me know where should set the Envelope and body xpath properties, as it is very confusing.

    I tried on all the Possibilities. 

    I really appreciate your help.



    Wednesday, January 20, 2010 11:23 AM