Important hotfixes for the biztalk oracle adapter
May 12, 2008 2 Comments
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
Abdul Rafay's BizTalk Blog 
These hot fixes are for Microsoft Adapter Pack 2.0 – Oracle Adapter Or for ODBC Adapter for Oracle
I am sending a message in which the data for an element whose datatype in oracle db is NUMBER allows null in oracle DB.
Our map has logic in which it checks for logical existence and thn map it wth tht element by using value mapping,if the file received has no value for this element thn it is checked by taking the inverse of logical existence thn mapping it to nil functiod which is mapped to the destination schema. test map gives correct output.
But when we do end to end testing it gives. Us NULL ,EXCEPTION.
I have tried almost everything,but I saw tht in orchestration debuggre the message which is sent to oracle database for Insertion has space in it rather than NULL value.
Kindly suggest.I need help on this .