Assign null value to datetime feild in Oracle for the Generated Schema using BAP V2.0

Hi,

    I have a problem inserting null value to Oracle Database.

I have generated a Schema from Oracle Database using the BizTalk Adapter Pack V 2.0.

I have three scenarios to work on

1)    
Input
XML with data a
<End_Date>2004-11-12 00:00:00</End_Date>

2)    
Input
XML with xsi:nil=”true” a
<End_Date xsi:nil=”true”
/>

3)    
Input
XML with no element tag. a Missing
Tag

Expected
Result :

  The
output for the scenario (2) should be the same as input

   The
output for the scenario (3) should suppress the element in the
XML.

Now I am getting the out for scenario 2 and 3 are same.

For Scenario 3 I need suppress the element in the output tag.

When I send the generated output from the map then its throwing an error

The
adapter failed to transmit message going to send port
“WcfSendPort_OracleDBBinding_Multiple_Custom” with URL
“oracledb://usto-ddbx-dmt01_rdwdev/”. It will be retransmitted after the retry
interval specified for this Send Port.
Details:”Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The
value for field “END_DATE” is invalid.

Server
stack trace:

   at
System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult
result)

   at
System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult
result)

   at
System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[]
outs, IAsyncResult result)

   at
System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult
result)

Exception
rethrown at [0]:

   at
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg,
IMessage retMsg)

   at
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type)

   at
System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult
result)

   at
Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult
result)”.

For more
information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Please help me out here to resolve the issue.

Thanks in advance

Regards

Mallesh B