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?