Important hotfixes for the biztalk oracle adapter

The important hotfixes that solved most of the problems that we were having are below. You can find all the hotfixes for the oracle adapter on the Microsoft Website.

• Error message when you use Microsoft BizTalk Adapter for Oracle Database and when you call a stored procedure on an Oracle server: “Error Code 6550″ When we had an input parameter with datatype number we were getting errors in the Event Viewer. You can download the hotfix from here
•  BizTalk Adapter for Oracle Database modifies the data in the DateTime field when you use the Insert method, the Update method, or the Query method We used this hotfix as well, you can download the hotfix from here.
•  An event may be logged when you use BizTalk Adapter for Oracle Database This happens when you have multiple datetime fields in oracle and when inserting a record in the table one or more fields are missed. You can download the hotfix from here
•  The Runtimeagent.exe process stops responding when you make concurrent calls by using BizTalk adapter This happened a lot of times when we were polling the Oracle database through the adapter although the time interval was 30 seconds, no even was logged and no error occurred. I didn’t notice and my development machine hanged as I got 5000 messages in an active state on BizTalk. You can download the hotfix from here