Hi,
I am trying to insert some records into an Oracle database from
Biztalk 2006 R2 using the Oracle Database Adapter.
I have used the standard way of generating the schema from the
database table, and everything is working fine except for one problem:
the database I am inserting records in is expecting for a particular
column to have a fixed width. For example if I want to enter the value
'20PBR01' I need to actually add four spaces in front of this to have
it recognised (so I have to insert ' 20PBR01'.
The problem is that when using the Oracle adapter the spaces get
removed, meaning that the input goes into the database but is not
usable by the application. I have checked the messages sent to the
adapter and I have seen that the spaces are in fact included in the
XML file sent to the send ****t of the Oracle adapter. I have also
tried replacing the spaces with nbsp escape codes but these are then
just transferred to the database (as it should be).
This seems like a straightforward thing but I haven't found a solution
for this anywhere. Can someone help on this?
Thanks,
Peter.
