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