none
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

    Thanks,!
    Tuesday, February 10, 2009 5:24 PM

Answers

All replies

  • This would be very helpful: http://www.biztalkgurus.com/media/p/15567.aspx

    -Firas
    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:
    http://www.biztalkgurus.com/forums/t/11659.aspx

    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

              -àP_RESULT_SET    

                  --à     Ns3:P_RESULT_SETRECORD

                                --à   Elements

     

    StoredProcedure name schema hierarchy.

    < Schema>

    ---à P_RESULT_SETRECORD

             --à   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.

     

    Murari


    Wednesday, January 20, 2010 11:23 AM