Oracle Db adapter and NUMBER data type

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Oracle Db adapter and NUMBER data type

Viewing 0 reply threads
  • Author
    Posts
    • #16259

      Hi all, I’ve this situation:

      ·         A source Oracle table where there’s a field that has NUMBER data type

      ·         A target oracle table where there’s an other field that has NUMBER data type again

      ·         A BizTalk orchestration that, using the Oracle DB adapter, reads that first table and writes the second; the Oracle adapter generate schemas where that fields have been remapped as a “xsd:String” Base Data Type with Derived By “Restriction”

      ·         The xml message generated as QueryResponse load the corresponding field with values as “-3,54678” (with the comma char), but it can’t be put on the target table because of the comma char (that should be a dot)

      ·         I’ve tried to change the data type remapping in the XSD schemas with “xsd:decimal”, but it seems doesn’t matter

       

      Have you any suggestions?

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.