none
Error while inserting NULL value to Oracle database table using BizTalk Adapter Pack 2.0 RRS feed

  • Question

  • We are using BizTalk Adapter Pack V2, WCF-Oracle DB adapter at BizTalk Send port to insert the data into Oracle table through stored procedure.
    All the columns of Oracle table have property Nullable as True.

    We have used Consume Adapter Service to generate the schema structure. The Schema elements have Nillable = True, Min Occurs =0

    During testing the BizTalk application, we have encountered two issues -
    1. When the element does not exist in the incoming message, Send port fails with following error -
           Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-06550: line 2, column 2:
           PLS-00306: wrong number or types of arguments in call to 'TEMP'
           ORA-06550: line 2, column 2:
           PL/SQL: Statement ignored
    2. When there is no value to a particular element,
    Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "SDATE" is invalid.
    or
    Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "SID" is invalid.System.ArgumentNullException: Value cannot be null.
    Parameter name: numStr

    Error mentioned in Second Scenario is generated only when the DataType is Integer or DateTime
    Error mentioned in first scenario occurs irrespective of DataType of the elements in the message.
    The all the elements are optional.

    Any solution/suggestion to resolve these issues is appreciated.

    Wednesday, March 3, 2010 7:55 AM

Answers

All replies