on 06-26-2009 9:44 AM
Hello,
Following is the message that I am trying to post to SQL server 2005 stored procedure input parameter from SAP PI
<MoveWeightNett isInput="true" type="varchar">4.890</MoveWeightNett>
<UnitOfWeight isInput="true" type="varchar">KG</UnitOfWeight>
<PurchaseOrders isInput="true" type="varchar" />
<TimeType isInput="true" type="varchar">WSHDRLFDAT</TimeType>
<MoveDateTime hasQuot="no" isInput="true" type="varchar" />
<DeliveryType isInput="true" type="varchar">DIG</DeliveryType>
<SenderSystem isInput="true" type="varchar">WCD320</SenderSystem>
For the MoveDateTime, I need to pass a NULL object to the stored proecdure. Can you please let me know how this can be done? The Interpretation of empty string values as NULL does not work. It sends NULL as a String.
Hi.
Please verify if MoveDate time is nullable and don't send this parameter.
Or maybe you can add this on the element xsi:nil="true"
Luis.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You got to check this in your SQL table. Check the SQL table if the MoveDateTime column is nullable.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.