WCF-Oracle Adapter Error RRS feed

  • Question

  • Hi,

    I get an error while using WCF_Oracle adapter.
    A message sent to adapter "WCF-OracleDB" on send port "Send_InsertOracleDB" with URI "oracledb://abc.MyUri.com/" is suspended. 
     Error details: Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "USERID" is invalid. ---> System.ArgumentNullException: Value cannot be null.
    Parameter name: numStr

    Here, the value that goes to 'USERID' is null/empty. Although 'USERID' element has Nillable as True and Min Occurs as 0. In Oracle database it's datatype is "NUMBER".
    This schema is generated by the "Add Generated Items". I'm not using any SP. It's a simple insertion schema that is generated.

    I have searched and tried many threads but found no useful answer. At some places it is written that it's issue with the adapter. Is it?

    Please help to resolve it. It's very urgent.

    Kunal G

    Thursday, November 29, 2012 9:12 AM